 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2007Help with mail merge
Hey there, thanks for the reply earlier. I am trying to mail merge using Outlook 2003. I am sending an email to 100 people and Outlook lets you select almost all the fields you want from Access. However I am having a problem merging results from particular customers. An example of this would be... In the Access database I have 100 customers. Each customer has 5 results which are listed below. If I create a repeat region using ASP in my website I get the following result. Name: Bob Product: Cars, Trees, Trams, Animals, Houses Email: email@email.com When I create a mail merge I get the following result. Name: Bob Product: Cars Email: email@email.com Name: Bob Product: Trees Email: email@email.com Name: Bob Product: Trams Email: email@email.com Name: Bob Product: Animals Email: email@email.com Name: Bob Product: Houses Email: email@email.com This also means that if I go ahead with the mail merge email, my client receives five seperate emails. Can anyone help with this issue? If not clear please ask any questions. Cheers Mally. That amounts to a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: If I had to do that, I would be doing it all in Access. However, for possibilities of using mailmerge in Word for it, 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  SignatureHope 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 > Hey there, thanks for the reply earlier. I am trying to mail merge using > Outlook 2003. I am sending an email to 100 people and Outlook lets you [quoted text clipped - 46 lines] > Cheers > Mally. |
Reply to this Message |
 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.