Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2008

Tip: Looking for answers? Try searching our database.

Multiple Entries for one Name

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DAB - 24 Apr 2008 23:10 GMT
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?  
Signature

Doug Small

Doug Robbins - Word MVP - 25 Apr 2008 03:45 GMT
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.

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 am running an event type Office 2007 access database.  I use the Mail
>Merge
[quoted text clipped - 11 lines]
> produce one confirmation email that includes the entrants name with all
> events entered?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.