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 / December 2005

Tip: Looking for answers? Try searching our database.

Access Word Mail Merge help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jasonrbaxter@gmail.com - 20 Dec 2005 18:10 GMT
I am using Access 2003 and Word 2003

I am successfully using mail merge with an access query as my data
source but I'm not sure how to include related records from other
tables and insert them in separate lines of the word document.

I want to include on the same page another connected table that have
multiple entries

For example:

RCA # _____________

Date: ______________

Technician's Name:_____________

Problems:                    Steps to complete
1. ______________       _______________
2. ______________       _______________
3. ______________       _______________

RCA#, Date and Technician are one table
Problems and Steps to Complete are connected to the other table.

Each RCA form has one or more problems.

Right now I have a form that has a print button.  When I press the
print button it takes the current record and creates a table (or
overwrites it).  It then through VBA opens Word with our existing form
where I have the various fields connected through the data source of
that newly created table.  I then open the data source and show the
merged fields.

When I'm doing this it will only show one problem because it is a basic
join query.  I need to make another query but I'm not sure what to do.

If you need any more clarification I'll be more than happy to give it
as this is complicated to explain.

Thank you,

Jason Baxter
Doug Robbins - Word MVP - 20 Dec 2005 18:50 GMT
I know exactly what you are trying to do, and if it was me, I would use a
report in Access to do it.

You are trying to perform a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Articles

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665

http://support.microsoft.com/default.aspx?scid=kb;en-us;294686

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using Access 2003 and Word 2003
>
[quoted text clipped - 39 lines]
>
> Jason Baxter
 
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.