Multiple Entries for one Name

[DAB]

I am running an event type Office 2007 access database. I use the Mail Merge
function to send entrants emails for confirmation of entry. This works fine
using queries for mail merge for one name and one event entry. My question
is: I want to use one name, who has signed up for multiple events, and have
the confirmation email select all the events the player has entered in one
confirmation email? I have produced a report that will list all entrants by
name which includes all entered events following each entrant name. How do I
produce one confirmation email that includes the entrants name with all
events entered?

 

[Doug Robbins - Word MVP]

This amounts to a "multiple items per condition (=key field)" mailmerge
which Word does not really have the ability to do:

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

or at:

http://cornell.veplan.net/article.aspx?&a=3815

however, you wanting to do this to email adds another complication and I
think that probably the only way to do it is by using VBA to create a
"roll-your-own" equivalent to mailmerge where you use a template in place of
the mailmerge main document and have your code create a new document from
that template for each player and populate that document with the events for
each player, then email it before proceding to the next player.


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