Mail merge - Calling individual records

[boxster]

Urgent! - Mail merge - Calling individual records

I have a mail merge that retrieves the data from an Access database. In the end, I should have 2 number of letters-each 2 pages- to be sent to 2 different people.

What I do now is to use the merge new document button or the next record button to print each of the letters separately. I want to have 1 document which has 4 pages-including both letters- so that I just have to use the print button and that's it.

Is there a way to call record#1 and record#2 in fields?

Thanks a lot!

 

[The_Doc_Man]

You are thinking about it slightly wrong, I think. It is not a "field" issue. Look into the MailMerge feature that allows you to create what they call a "Catalog" style of merge.

If this is really a form letter, this catalog sytle of merging would allow you to create as many letters as you need in a single operation. The letters would be part of a single file, so it would be a single print operation. You would have to assure that the merge template has a page break in the right place to keep your letters on separate pages, though.

 

[boxster]

Thanks a lot for your reply. When I press "Merge to New Document" button, all the pages come up as I want, and I can print them all at once. However, I am trying to eliminate the "Merge to New Document" proces - if it is possible...

 

[The_Doc_Man]

Well, it is possible to include some VBA code that could do this for you behind the scenes. I've never done it, but there is a DoCmd option that probably could do this for you from Access. Or maybe we aren't communicating quite right yet, 'cause I'm still a bit confused about what you really want.

 

[neileg]

Please don't double post. I've posted an answer to this query in the Word forum already.