Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2004

Tip: Looking for answers? Try searching our database.

Merging Mailing Labels from Outlook 2003 Contacts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brent - 21 Mar 2004 01:31 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.