Mail Merge With Second Recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

killianbannon@gmail.com - 25 Nov 2006 22:10 GMT

I have to do out a system (in Access) which will output using vba a
mail merged word document.
However, each letter will need the ability to be customised by the
client (I know they will wreck it but thats what they want).
Each letter will have the usual MM stuff - names, addresses, dates but
half way down through the letter it will show a table containing their
account details since the last MM ran.
The only way I can see this is to use a second recordset - but is this
possible?
Thanks

Reply to this Message

Doug Robbins - Word MVP - 26 Nov 2006 13:38 GMT

If they did not want to "customize" the documents, I would say to do it all
in an Access report where it is quite easy. Even if they want to
"customize" the documents, I would still probably do it in Access and then
export the report to .rtf.

It cannot be done with out-of-the-box mailmerge in Word.

See 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

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

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 have to do out a system (in Access) which will output using vba a
> mail merged word document.
[quoted text clipped - 6 lines]
> possible?
> Thanks

Reply to this Message

killianbannon@gmail.com - 26 Nov 2006 22:08 GMT

Thanks Doug
They want it customizable so that rules out reports etc. I'll read
through those links.
KB

Reply to this Message