Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-31-2010, 07:45 AM
awalker1970 awalker1970 is offline Mail Merge - Many Records for Each Addressee Windows XP Mail Merge - Many Records for Each Addressee Office XP
Novice
Mail Merge - Many Records for Each Addressee
 
Join Date: Dec 2010
Posts: 1
awalker1970 is on a distinguished road
Default Mail Merge - Many Records for Each Addressee

Hi,

This is having me tearing my hair out!

I want to send a letter to a number of suppliers, each of which has a number of different contracts with our company i.e.

Supplier X will have Contract 1 and Contract 2
Supplier Y will have Contract 3 and Contract4

I don't want to send lots of different letters to the same supplier, just one detailing all the the contracts they have.

At the moment the data is in Excel.

I think the answer may be in using Access (One to Many Relationship?) or using Field codes in Word. I can set up tables and queries in Access, so would prefer that way.

Any ideas.

Thanks,



Andrew
Reply With Quote
  #2  
Old 12-31-2010, 11:52 AM
macropod's Avatar
macropod macropod is offline Mail Merge - Many Records for Each Addressee Windows 7 32bit Mail Merge - Many Records for Each Addressee Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Andrew,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Many Records for Each Addressee Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
Mail Merge - Many Records for Each Addressee Combine Records when Mail Merge from Access Tom Pickles Misc 2 08-24-2010 06:00 PM
Mail Merge hiteshkataria Mail Merge 4 11-06-2009 05:11 AM
Mail Merge Mohanss82 Mail Merge 0 01-21-2009 12:29 PM
Help with consolidating multiple records into one wbiggs2 Excel 0 11-30-2006 01:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft