Hello.
I'm trying to merge all of my Outlook 2003 contacts onto
mailing labels, and have become stuck because I cannot
find an easy way for the "merge" button to become
available in Word's Merge helper window.
The button will not become available even after
hitting "setup" and choosing a label size, the data source
is already set because it was a direct import from
Outlook's mail merge menu...the only other choice which I
don't really know how to use is "query options."
I've read up, and to import the whole address block, I'm
supposed to choose "Mailing_Address". When I choose this,
it brings up the equal to, blank, and, blank fields. I
have no idea what to put in there. I just want to insert
mailing address and have that be it.
Many thanks for any help on this. I am able to do this
when exporting a .csv, but I'm hoping for an easier
solution....which I'd think this would be.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 21 Mar 2004 01:57 GMT
From the View menu, Select Toolbars and then check the Mailmerge item so
that the Mailmerge toolbar appears and use that rather than the Wizard.

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> Hello.
>
[quoted text clipped - 18 lines]
> when exporting a .csv, but I'm hoping for an easier
> solution....which I'd think this would be.
Brent - 21 Mar 2004 04:27 GMT
I appreciate your help Doug. That's not very satisfying
though. So this "tool" in Outlook for a mail merge
directly into a new document just doesn't work? Does it
have a bug that causes it not to work?
I'm trying to show a client how to do a mail merge from
their Outlook contacts - and I want the easiest solution
possible. I was hoping we wouldn't have to export a file,
browse to a database or find an address book. This direct
choice to mail merge from Outlook would be ideal...it's
seems weird to me that it doesn't work. I felt I had my
settings wrong or something.
I was hoping this could be a 5 step process instead of
10...
>-----Original Message-----
>From the View menu, Select Toolbars and then check the Mailmerge item so
[quoted text clipped - 24 lines]
>
>.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 21 Mar 2004 08:56 GMT
Brent,
It does work. I guess you just have to know how to work it.
After you select Mailing Labels from the Document type pulldown in the
Outlook "Mail Merge Contacts" dialog and click on the OK button, the paper
clip guy tells you to click on the Setup button in the Mail Merge Helper
dialog. That takes you to the Label Options dialog where you select the
label product that you want to use and click OK. You then either Click on
the Edit button in Section 1 of the Mail Merge Helper dialog and select the
document that is listed there or just close that dialog. As a result of
some step in the above process, the Mail merge toolbar in Word is made
visible. On that toolbar, you have to click on the 6th button from the
left, the Insert Merge Fields button which will display a dialog box
containing all of the fields from the Outlook Contacts. After setting up
the fields in the way that you want them in the first label on the sheet,
you must click on the 11th button from the left (Propogate Labels) which
will replicate the setup of the mergefields onto all of the labels on the
sheet. Then you execute the merge by using one of the buttons on the
right - either to a new document, or the printer.

Signature
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
>I appreciate your help Doug. That's not very satisfying
> though. So this "tool" in Outlook for a mail merge
[quoted text clipped - 56 lines]
>>
>>.
Graham Mayor - 21 Mar 2004 09:18 GMT
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm
and http://www.gmayor.com/mailmerge_from_outlook.htm
Start the merge from Outlook (see latter link) and use the techniques
described in the first link to create your labels.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
> Hello.
>
[quoted text clipped - 18 lines]
> when exporting a .csv, but I'm hoping for an easier
> solution....which I'd think this would be.