Mail Merge

[Gina]

I need to put several addresses in a document but only send it to one how do
I do that???

 

[KARL DEWEY]

Post the SQL of your query that will be grouping these adresses.

 

[KD]

I am using MSN for my document and Access for my data base both 2007

 

[KARL DEWEY]

So how are you going to group the addresses?
What is your criteria?

 

[Gina]

I need to send a letter to one one owner with alot of the property addresses
in the body of the letter....and then to another owner with different
addresses in the body I really don't know how to do this can anyone help??????

 

[Gina]

I need to send a letter to rental property owners..about the properties they
own, some have 2 properties some have 8 but I need to send 1 letter for
numerous property addresses I can do the basic application but I don't want
to send 5 letters to the sane person and I don't want to write out 500
letters...HELP PLEASE!!!!!

 

[KARL DEWEY]

You have two kinds of addresses - mail and property. So you need to
distinguish between them. How do you do this? Are they in separate tables
or in same table with a flag? How do you relate the mail to the property
adresses?

Post your table structure - table and field names with data type.

 

[Gina]

I have an access data base and in the data base I have the property address
and the owner name and their mailing address I am doing the letter in word...
I can do the letter and get each property address as well as owner info but I
wanted to put all of the property address to each owner on one letter rather
than multiples

 

[KARL DEWEY]

I have an access data base and in the data base I have the property address
and the owner name and their mailing address

You did not answer my questions about your database.

 

[Gina]

Ok I think you want to know this... I have the information in a table, In the
headers on each column I have....Site Address 1, site address 2, Name,
Mailing address, Mailing city/ state, zip I don't have anything flagged..at
least I don't think so! I really appreciate your help..

 

[KARL DEWEY]

I found this earlier post --------
See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.