mailmerge MS Access multiple records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EiEiohh - 20 Feb 2008 04:52 GMT

Hi All
I am using data from a MS Access query for mail merge.
The merged letter will include multiple "enclosures" from the query.
I need to merge all "enclosures" from the query onto the document.

any ides?
TIA

Reply to this Message

Peter Jamieson - 20 Feb 2008 08:25 GMT

It sounds as if you are attempting a "multiple records per item" type merge,
in which case the main starting point is e.g.

http://support.microsoft.com/?kbid=294686

If that isn't what you are trying to do, can you spell out the requirement a
bit more - are your enclosures typical letter enclosures (extra pages of
various kinds) and does each enclosure correspond to a row in the query
results, or what?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Hi All
> I am using data from a MS Access query for mail merge.
[quoted text clipped - 3 lines]
> any ides?
> TIA

Reply to this Message

Doug Robbins - Word MVP - 20 Feb 2008 11:38 GMT

Sounds to me like you should be using a report in Access. It can handle
this sort of thing better than Word.

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

> Hi All
> I am using data from a MS Access query for mail merge.
[quoted text clipped - 3 lines]
> any ides?
> TIA

Reply to this Message