By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,956 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,956 IT Pros & Developers. It's quick & easy.

Access to Word Mail merge

P: n/a
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

Aug 7 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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?
Simon wrote:
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
Aug 7 '06 #2

P: n/a
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 wrote:
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?
Simon wrote:
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
Aug 7 '06 #3

P: n/a
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.
CaptainDahlin wrote:
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 wrote:
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?
Simon wrote:
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
Aug 7 '06 #4

P: n/a
"Jeff L" <jl*******@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.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/AlbertKal.../msaccess.html

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

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 7 '06 #5

P: n/a
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)?

Dec 25 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.