Mail merge with DB (access/SQL) record source as a merge item

[John King]

Hi:

I'd like to use a Word mail merge to send customers data
on items that they own.

To date, I've been using Microsoft Access reports to do
the job, but Access can be somewhat limiting in how nice
the document can look. So, my question is this:

Is there a way to do a Word mail merge and embed the
results of a query?

For instance, send 50 customer letters out, each letter to
a different customer, and each letter detailing the
licenses that the customer owns.

It's not obvious to me that it is possible> I mean, I
don't even see that I can embed an Access object/file in a
Word document, but some of the things I've read here give
me the impression that it is possible to do.

If possible, I don't want anyone to go into great detail,
just some pointers where I would look in Help or on the
web for the additional information would be a great help.

I've poked around and just haven't found anything I
recognize as an answer.

Thanks for your time,

JK

 

[Doug Robbins - Word MVP]

You can actually do some pretty fancy things with an Access Report.

However, see the "Multiple items per condition" item under the "Special
merges" section of fellow MVP CIndy Meister's website at

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

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[jdbcguy]

You can actually do some pretty fancy things with an Access Report.

However, see the "Multiple items per condition" item under the "Special
merges" section of fellow MVP CIndy Meister's website at

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

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

There is a product called Super*SQL that recently became available.
It allows you to pull information from an Access database and create
HTML reports using a batch process with command line parameters (like
user, for example). I'm not sure how you would get the E-mail portion
working (depends upon your E-mail backend), and HTML may not be the
right answer for your reports but it could be worth looking at. I
found it at www.sqlmagic.com.

 

[IainMac]

If all your data is in a query then create your form letter in word (do all the fancy stuff you want to try) and then for the second part of the merge 'open' a data source and navigate to the database and then the relevant query. Insert the necessary fields where required and finally merge to create your personalised letters.