A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Suppressing Mail Merge Wizard and using menus instead



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2004, 02:28 PM
Margaret Hargreaves
external usenet poster
 
Posts: n/a
Default Suppressing Mail Merge Wizard and using menus instead

Hi

I sincerely hope Susanna Barnhill sees this as I
understand she has previously sent info to this forum
which I appear to have missed.

At the moment, Mailmerge is really getting to me having
to go through that long-winded wizard process and I long
to convert back to the old days of using menus. Can
anyone help.

Also, in the old days pre wizard, you could create your
database for a particular letter which could subsequently
be opened and was, in fact, a table in Word. Is this
still possible as the wizard seems to want to write
everything to Access!! However, I'm aware you can select
a spreadsheet instead.

However, in the old days, a very helpful feature of the
merge menus was the "merge options" which seem to have
disappeared. Now, instead of selecting, for example,
everyone with a postal town of Bristol you have to scan
the entire list checking every line where you want the
information included in the merge. This takes forever.
How do I get the old merge options back please?

Any help will be very gratefully received.

Thank you.
  #2  
Old June 1st, 2004, 04:35 PM
JulieD
external usenet poster
 
Posts: n/a
Default Suppressing Mail Merge Wizard and using menus instead

Hi Margaret

came across this amazing tip the other day (not sure where but i'm eternally
greatful!) ..

choose view / toolbars / customize
choose the commands tab
under categories choose all commands
on the right hand side find Mail Merge Helper
drag to toolbar
close customize dialog
click on mail merge helper
and yay!!!!!!!!!!!!!

hope this helps

Cheers
JulieD


"Margaret Hargreaves" wrote in message
...
Hi

I sincerely hope Susanna Barnhill sees this as I
understand she has previously sent info to this forum
which I appear to have missed.

At the moment, Mailmerge is really getting to me having
to go through that long-winded wizard process and I long
to convert back to the old days of using menus. Can
anyone help.

Also, in the old days pre wizard, you could create your
database for a particular letter which could subsequently
be opened and was, in fact, a table in Word. Is this
still possible as the wizard seems to want to write
everything to Access!! However, I'm aware you can select
a spreadsheet instead.

However, in the old days, a very helpful feature of the
merge menus was the "merge options" which seem to have
disappeared. Now, instead of selecting, for example,
everyone with a postal town of Bristol you have to scan
the entire list checking every line where you want the
information included in the merge. This takes forever.
How do I get the old merge options back please?

Any help will be very gratefully received.

Thank you.



  #3  
Old June 1st, 2004, 04:38 PM
JulieD
external usenet poster
 
Posts: n/a
Default Suppressing Mail Merge Wizard and using menus instead

Hi Margaret

me again

in addition to my other response you can also set filter options in step 5
of the mail merge wizard ... click on Edit Recipient List
click on the DROP DOWN arrow on the field that you want to filter on
choose the item that you want OR click on the Advanced tab

Cheers
JulieD

"Margaret Hargreaves" wrote in message
...
Hi

I sincerely hope Susanna Barnhill sees this as I
understand she has previously sent info to this forum
which I appear to have missed.

At the moment, Mailmerge is really getting to me having
to go through that long-winded wizard process and I long
to convert back to the old days of using menus. Can
anyone help.

Also, in the old days pre wizard, you could create your
database for a particular letter which could subsequently
be opened and was, in fact, a table in Word. Is this
still possible as the wizard seems to want to write
everything to Access!! However, I'm aware you can select
a spreadsheet instead.

However, in the old days, a very helpful feature of the
merge menus was the "merge options" which seem to have
disappeared. Now, instead of selecting, for example,
everyone with a postal town of Bristol you have to scan
the entire list checking every line where you want the
information included in the merge. This takes forever.
How do I get the old merge options back please?

Any help will be very gratefully received.

Thank you.



  #4  
Old June 1st, 2004, 04:54 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default Suppressing Mail Merge Wizard and using menus instead

Hi Margaret,

I sincerely hope Susanna Barnhill sees this as I
understand she has previously sent info to this forum
which I appear to have missed.

Even when she's around, Suzanne rarely checks this
newsgroup. Mail merge isn't her specialty :-)

At the moment, Mailmerge is really getting to me having
to go through that long-winded wizard process and I long
to convert back to the old days of using menus. Can
anyone help.

You can get back the old interface. The information is in a
table in the Word 2002 section of my website's mail merge
FAQ.

you might also try using the toolbar (my preference).

Also, in the old days pre wizard, you could create your
database for a particular letter which could subsequently
be opened and was, in fact, a table in Word. Is this
still possible as the wizard seems to want to write
everything to Access!! However, I'm aware you can select
a spreadsheet instead.

You can still use a table...

However, in the old days, a very helpful feature of the
merge menus was the "merge options" which seem to have
disappeared. Now, instead of selecting, for example,
everyone with a postal town of Bristol you have to scan
the entire list checking every line where you want the
information included in the merge. This takes forever.
How do I get the old merge options back please?

The Recipients dialog box, you mean. You can select a
criterion from the list at the top of a field. Or, the very
last entry in that list will get you into the old Query
Options.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

  #5  
Old June 1st, 2004, 08:12 PM
Margaret Hargreaves
external usenet poster
 
Posts: n/a
Default Mailmerge - old style

Hi Julie

Many thanks. I've tried it and it's womderful. Thanks a
bunch.

Regards
Margaret
-----Original Message-----
Hi Margaret

me again

in addition to my other response you can also set filter

options in step 5
of the mail merge wizard ... click on Edit Recipient List
click on the DROP DOWN arrow on the field that you want

to filter on
choose the item that you want OR click on the Advanced

tab

Cheers
JulieD

"Margaret Hargreaves"

wrote in message
...
Hi

I sincerely hope Susanna Barnhill sees this as I
understand she has previously sent info to this forum
which I appear to have missed.

At the moment, Mailmerge is really getting to me having
to go through that long-winded wizard process and I

long
to convert back to the old days of using menus. Can
anyone help.

Also, in the old days pre wizard, you could create your
database for a particular letter which could

subsequently
be opened and was, in fact, a table in Word. Is this
still possible as the wizard seems to want to write
everything to Access!! However, I'm aware you can

select
a spreadsheet instead.

However, in the old days, a very helpful feature of the
merge menus was the "merge options" which seem to have
disappeared. Now, instead of selecting, for example,
everyone with a postal town of Bristol you have to scan
the entire list checking every line where you want the
information included in the merge. This takes forever.
How do I get the old merge options back please?

Any help will be very gratefully received.

Thank you.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.