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 / April 2007

Tip: Looking for answers? Try searching our database.

Mail merge fails in 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 04 Apr 2007 09:30 GMT
I have a Word document (target) I want to mail merge with an excel sheet
(source). I have followed the 6 prompts in the mail merge wizard in Word.  
but when I come to step 5 (Preview your letters) the data from Excel doesn't
show in the address block that I inserted in Word for step 4.
The data certainly shows up when I "edit recipient list" in step 3 and I
have checked the  boxes for the recipients I want. What am I missing?

An IT guy here at work said to make sure there was no blank in the first
cell of the column but I tried this but no luck
Peter Jamieson - 04 Apr 2007 09:56 GMT
When trying the following you will need the MailMerge toolbar which you can
enable in Tools|Customize. IMO in most cases it's easier to work with than
the Wizard anyway.

On the toolbar, use button 6 to insert one or more individual merge fields
that you would expect to be included in your ADDRESSBLOCK. Preview the
document again (button 8 on the toolbar). If you don't see your data, I
don't know what is happening, but post again.

If you do see your data, then the ADDRESSBLOCK is probably not working
because you have not "mapped" your Excel field names. At this point you can
go in two directions:
a. abandon the use of ADDRESSBLOCK and use individual fields instead. See,
e.g. Graham Mayor's article at
http://www.gmayor.com/formatting_word_fields.htm
b. click button 10 on the toolbar ("match fields") and tell Word which
field names in your data source correspond to the field names in its
standard list. The point is that Word tries to recognise your field names
and do this mapping (or matching) automatically, but if you do not use field
names that Word recognises, you have to do the mapping/matching yourself.

Peter Jamieson

>I have a Word document (target) I want to mail merge with an excel sheet
> (source). I have followed the 6 prompts in the mail merge wizard in Word.
[quoted text clipped - 6 lines]
> An IT guy here at work said to make sure there was no blank in the first
> cell of the column but I tried this but no luck
Graham Mayor - 04 Apr 2007 11:01 GMT
Actually my other merge page
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  is probably more
relevant here :)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When trying the following you will need the MailMerge toolbar which
> you can enable in Tools|Customize. IMO in most cases it's easier to
[quoted text clipped - 29 lines]
>> the
>> first cell of the column but I tried this but no luck
 
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.