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 / April 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John King - 15 Apr 2004 05:06 GMT
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 - 15 Apr 2004 09:13 GMT
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

Signature

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

> Hi:
>
[quoted text clipped - 27 lines]
>
> JK
jdbcguy - 15 Apr 2004 16:32 GMT
> You can actually do some pretty fancy things with an Access Report.
>
[quoted text clipped - 34 lines]
> >
> > JK

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 - 15 Apr 2004 23:36 GMT
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.
 
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.