Create Contact Mailing List + Database
by clovejoy - 5/9/08 3:06 PM
I'm working with Microsoft Access/Excel/Word 2007, and I don't care which program has the solution...
I need to be able to create two different kinds of reports from my contact database.
1) A page/form/whatever for each organization in my database with all of the contacts from the company (and other info from the database)
2) A mail merge that allows me to send mail to every contact.
The problem is that if my database is created so that each organization is on one row (with contacts listed in the row), I can't pull each contact separately into a mail merge. However, if I create the database with each contact having its own row, I can't pull the contacts from each organization into one document.
My old company solved this problem by doing both. There was one row for the organization with all of the contacts listed and then seperate rows repeating the information for each of the contacts. This is extremely cumbersome and caused all kinds of consistency problems in the database.
I'm looking for either a different way to create the database so I don't have to enter any data twice, or a different way to pull the data. So far I've tried macros in Access, mail merge in Word and pivot tables in excel. I'm not very advanced in any of them though, so it's very possible I'm missing something. (For example, can you mail merge a pivot table?)