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 / May 2008

Tip: Looking for answers? Try searching our database.

merging multiple records into the same

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Reed - 27 May 2008 23:32 GMT
I am mail merging records from Access. I am merging multiple records into
the same document. This works fine until I need to place fields from the same
record
in different places in the document. example: I first list the names (using
data fields and word field "next) from multiple records and elsewhere in the
document I need to insert other information (data fields) from the same set
of records. If I simply add "data fields" at the location in the document , I
just get blanks.

I need to be able to have the merge do something like a "go to first record"
on the whole database and continue.  Or, a command that resets the next
record position i.e. "go to first record in the database"...

Example:

BODY TEXT..etc.... Name List:
{MERGEFIELD "NAME"} {NEXT}    
{MERGEFIELD "NAME"} {NEXT}
{MERGEFIELD "NAME"} {NEXT}
{MERGEFIELD "NAME"} {NEXT}

MORE BODY TEXT...etc..Unit List:
{MERGEFIELD "UNIT"} {NEXT}
{MERGEFIELD "UNIT"} {NEXT}
{MERGEFIELD "UNIT"} {NEXT}
{MERGEFIELD "UNIT"} {NEXT}  

It is after the "MORE BODY TEXT.." that I need to go to the first record in
the query and merge "UNIT"  creating a list of "Units".  The "NAME" and
"UNIT" are fields in the same record.  I could make a separate table for the
"UNIT" data if that would help me accomplish the task.

Thanks for any help.
Doug Robbins - Word MVP - 28 May 2008 03:56 GMT
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do.

The way I would do it would be with a report in Access.

However, you might get some ideas from 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 Article

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

or at:

http://cornell.veplan.net/article.aspx?&a=3815

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 mail merging records from Access. I am merging multiple records into
> the same document. This works fine until I need to place fields from the
[quoted text clipped - 37 lines]
>
> Thanks for any help.
 
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.