Access to Word Mail merge

[Simon]

on my database i have a customers Table (tblCustomers) on the form of
it (frmCustomers) i would like a button what will open up word and open

up my comapny letter head template and then merger the customer details

currently on the form into the Word letter so i can send an individual

letter.

Can any one help me

Thanks

Simon

[Jeff L]

You are going to need a data source for your mail merge. I would
suggest a query that selects all the relevant information, but that
refers to your form for the correct CustomerID. In the criteria of the
CustomerId in the query, put Forms!frmCustomers!CustomerID. Did you
need help with setting up the actual document too or did you just not
know how to connect the data?

[CaptainDahlin]

I would like to do something similar. I have done a simple mail merge
before and have set the data source to a table. How would Word know
what the resulting query would be if it depends on a drop down box on
an access form? I thought the data source was set pretty much at design
time...

[Jeff L]

I misinfomed you. The reference to the form cannot be used and I
thought that it could. You could run a make tbl query that creates
you record source for your mail merge. In that Make Tbl query you
could refer to the form to grab the person you need. Sorry about the
mixup.

[Albert D. Kallal]

"Jeff L" <jlec...@hotmail.com> wrote in message
news:1154973437.2...@m79g2000cwm.googlegroups.com...

>I misinfomed you. The reference to the form cannot be used and I
> thought that it could. You could run a make tbl query that creates
> you record source for your mail merge. In that Make Tbl query you
> could refer to the form to grab the person you need. Sorry about the
> mixup.
>

Actually, I have a working example that automatically builds the merge based
on the current form.

This means that you can word-enable ANY form in your application with ONE
LINE of code, and the data source
for word will be setup for you auto-matic. This means my example solves 99%
of the merge issues that come up
when working with a application, and ANY form data can instantly be merged
to a word template with one line of
code (the default is to merge the CURRENT ONE record).

You can find this code example here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The the above exmaple...it should solve both of your requests...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com

[DaveM54]

Your WordMailMerge is terrific, but how do I change the default data source
to a specific query (that contains information from two or three tables)?