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 / July 2004

Tip: Looking for answers? Try searching our database.

Fields not pulling through

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark Atkin-Barrett - 01 Jul 2004 17:56 GMT
Hi all, hoping someone out there can help!!!

I have created an Excel spreadsheet containing my information (list of names
and addresses) and i am trying to mail merge the information into a letter i
have written in Word. Although i select fields "Address 1 - Address 4 and
the post code) it seems to leave out the information contained in fields
"Address 3 & 4...when merging across to my letter in Word.

Hope all this makes sense, thanks in advance

Mark
Peter Jamieson - 01 Jul 2004 23:45 GMT
> Hi all, hoping someone out there can help!!!
>
[quoted text clipped - 3 lines]
> the post code) it seems to leave out the information contained in fields
> "Address 3 & 4...when merging across to my letter in Word.

How are you inserting the address information into your merge letter? In
Word 2002/2003, there are two possible ways:
 a. use an ADDRESSBLOCK field. This is probably not a very good idea in
this case because
    i) ADDRESSBLOCK is not really geared to addresses structured the
way you have them. It's geared to look for "street address", "city",
"country" etc.
    ii) Word probably won't recognise your field names and you will
have to "map" the fields it expects to insert to the names you are using
 b. use individual fields. In this case you need to insert something
like the following (use your exact field names)

{ MERGEFIELD "Address 1" }
{ MERGEFIELD "Address 2" }
{ MERGEFIELD "Address 3" }
{ MERGEFIELD "Address 4" }
{ MERGEFIELD Postcode }

where the {} are the special field braces you can insert using ctrl-F9.

But the main point is that either way, Word will not automatically use
whatever fields you have selected from your data source - you must
either "map" the fields you need (with ADDRESSBLOCK) or insert all the
MERGEFIELDs you need.

Peter Jamieson

Rate this thread:






 
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.