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 / October 2003

Tip: Looking for answers? Try searching our database.

Merging an Access Database into a Word Mail Merge Letter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Farah - 03 Oct 2003 20:41 GMT
Hello,

I am trying to merge my data from Access into a mail
merge letter in Word. Any idea how to go about it? When I
created my mail merge letter in Word, it created a
database but in Access it just comes under "Office List"
and doesn't include the other fields I want for my Access
database. Anyone have any answers for me?

Thanks!
Peter Jamieson - 04 Oct 2003 08:48 GMT
Assuming you are using Word/Access 2002 (let us know which version if you
are not),

If you are trying to use an existing Access database, then when you get to
Step 3 in the wizard, click the Browse... option and select your .mdb as the
data source.

If you are using the "Type a new list" option what happens is that Word
creates a new .mdb with a very specific structure - it has one table called
Office_Address_List and one query called Office Address List. Word gets its
data from the query.

You can open this .mdb in Access, modify the fields in the table in the
usual way, and use either the table or the query as a data source for a
merge, but once you have made structural changes, Word will probably not
recognise the .mdb as an Office Address List any more - you will be led
through a slightly different dialog to select the table/query you want to
use. Also, you can edit the contents of an Office Address List in Word's
Edit Recipients dialog box, but with any other .mdb the Edit button is
greyed out, so you have to use Access to edit the data.

--
Peter Jamieson
MS Word MVP

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thanks!
 
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.