Mail Merge Access and Word with cover letter and detail pages

[molly]

The search here is under maintenance right now. So I need to ask a general question now before I waste time looking at my Word book or buying more books.

I presently have an Access Report that has a cover letter Header followed by many formula records with data. I have a page break. So I get a cover letter that prints page 1 and then pages 2 and 3 are the detail pages with formula products. I have a BMP signature on the cover letter.

I print the cover letter on pre printed letterhead paper which has a logo.

Now the problem. I am asked sometimes to email the letter. So i have file exported the file using RTF format and once it is in Word, I save it in Word with Word format.

But the signature does not come in. And if i had used the company logo, i know that would also not come in.

Someone said to try mail merging with Word. But will my 2 pages of detail records also merge into the Word?? That is my question.

Molly

 

[dhookom]

There is functionality in Word that allows for moving through records in a single document. It's difficult to find in Help but I believe involves the {NEXT} merge field. I expect you can find good resources by searching google.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Spenney]

Create a Snapshot or PDF of the report?