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 / October 2003

Tip: Looking for answers? Try searching our database.

Sophisticated Mail Merge Possible?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
A Lougheed - 28 Oct 2003 16:13 GMT
We have a form mailing which doesn't follow the normal
mail merge process.  We will be running the mail merge
from a database and here is what we want to do:

############ FORM ##############
John J. Doe   (From Billing Contact Record)
AAA Company, LLC  (From Company Record)
3815 Company Address (From Billing Contact Record)
Indianapolis, IN 46240 (From Billing Contact Record)

Dear William:

We truly appreciate <CompanyName>'s membership.  In an
effort to make it even more valuable for you and other
affiliate members within your organization, we are asking
that you take a few moments to review the information we
have on file, making any corrections as necessary, and
returning to us.

        Contact Name
        Contact Address
        Contact Phone
        Contact email address

        Contact Name
        Contact Address
        Contact Phone
        Contact email address

Contact Name
        Contact Address
        Contact Phone
        Contact email address

############ END FORM #############

The above would continue to repeat until all "contacts"
from that Company have been listed. In some cases there
will only be one contact, in others there may be as many
as 50.

Our database is in FileMaker.  Made up of a number of
tables, including "Companies" and "Contacts", both of
which have a unique identifying number.  In the Contact
record is a field for Company ID number..that is how
Contacts are associated with Companies.

I can export records to Excel in the format I showed in
my email, shown again here:

Column A        Column B        Column C,
etc.
Company 1    Contact 1001    Contact Address, email
etc.
        Contact 2001    Contact Address, email
etc.
Company 2    Contact 1021    Contact Address, email
etc.
        Contact 3001    Contact Address, email
etc.
        Contact 1004    Contact Address, email
etc.
        Contact 1501    Contact Address, email
etc.
Etc   etc   etc

I can also export so that the Company Name shows up on
all records if that were needed.

This is a very difficult question and I will award more
points.

Thanks so much, April
Peter Jamieson - 28 Oct 2003 17:17 GMT
Have a look at Cindy Meister's article at

http://homepage.swissonline.ch/cindymeister/

Look for Mail Merge FAQ, Special Merges, Multiple items per condition.

--
Peter Jamieson
MS Word MVP

> We have a form mailing which doesn't follow the normal
> mail merge process.  We will be running the mail merge
[quoted text clipped - 69 lines]
>
> Thanks so much, April
 
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.