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

Tip: Looking for answers? Try searching our database.

Help with Access -> Word Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Meyer - 12 Jan 2004 00:07 GMT
Hello!

I am doing my best to develop a database that automates
the generation of a series of Test Cases using the Mail
Merge feature of Microsoft Word to import information from
an Access Database.

I can get all the fields to fill out correctly from EXCEPT
for the fields that are Many to One.

For example, each Test Case has a list of Test Procedures,
numbered sequentially.  In the Access Database this is
represented by two tables, of course, to represent the
Many to One relationship.

I have built a query to combine the tables into one data
source for Mail Merge.

Is it possible to create a Mail Merge function that will
append ALL the Procedure entries into the single Word
Document?

Thank you for your prompt and intelligent replies.
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 12 Jan 2004 04:15 GMT
Hi Jim,

Why not do it all in Access?

But, see the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm
Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> Hello!
>
[quoted text clipped - 19 lines]
>
> Thank you for your prompt and intelligent replies.
Sharon - 12 Jan 2004 19:20 GMT
I struggled and struggled and struggled with just this
issue!  I am not an expert in Access and/or Word, but I
did it.  I don't always use the terminology that is up-to-
date, but I got the job done.  Feel free to e-mail me and
maybe I can explain how I did it.  Thanks.
>-----Original Message-----
>Hello!
[quoted text clipped - 22 lines]
>
>.

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.