Mail Merge With Second Recordset

[killianbannon]

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

 

[Doug Robbins - Word MVP]

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


--
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

 

[killianbannon]

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