 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Document Management / May 2008Word 2003 Mail Merge
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. ie I first list the name fields from multiple records and later in the document I need to insert other information (fields) from the same set of records. If I simply add to code to merge the other fields, I just get blanks. I need to be able to have the merge do a sort of global "next" on the whole database. Like "go to first record in the database and continue"... Any idea would help. Thanks > 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 [quoted text clipped - 10 lines] > > Thanks It's not clear what you are trying to do. When you say "list the name fields from multiple records" it sounds like you might now know how merge works. Each final document, after the merge, will contain data from one record. I don't think it's possible to end up with data from multiple records in one document.  SignaturePeter Aitken Author, MS Word for Medical and Technical Writers www.tech-word.com > > 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 [quoted text clipped - 16 lines] > from one record. I don't think it's possible to end up with data from > multiple records in one document. I have merged multiple records into the same document using the Word Field "next" and "next if", so it is possible. However, I would know if there is a code or Word Field that will reset the start position of "next" record> There is no way of going back to the first record. See response to your post in the mail merge fields newsgroup. SignatureHope 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 >> > Mail merging records from Access. I am merging multiple records into >> > the same [quoted text clipped - 27 lines] > is a > code or Word Field that will reset the start position of "next" record> As Doug said, there isn't a way to do anything like that with mail merge features. I would think you need to create an Access query that pulls the data in that manner based on whatever the unique factor is that would cause the record to be called multiple times. That query can then be used as a record source to generate the merge. I'm having trouble visualizing such a record set, though. Regards |:>) Bob Jones [MVP] Office:Mac On 5/27/08 1:50 PM, in article DA453995-D264-444F-BC6E-A26F3A8A6793@microsoft.com, "Reed" > 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 [quoted text clipped - 10 lines] > > Thanks |
Reply to this Message |
 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.