Linking data from a form to ms word

S

SCP

I have a form which has lots of different formulas that I use as an insurance
calculator to give customer quotes. I want to merge the data to a template
that I have set up on ms word - is this possible.
Thankyou
 
A

Arvin Meyer [MVP]

SCP said:
I have a form which has lots of different formulas that I use as an insurance
calculator to give customer quotes. I want to merge the data to a template
that I have set up on ms word - is this possible.
Thankyou
Click to expand...

Have a look at the code on my website, that does just this:

http://www.datastrat.com/Code/WordMerge.txt

The merge is acomplished using Word bookmarks.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
S

Sheila D

If the form is generated by a Select query then use that query in step 2 of
the mail merge as the data source

Sheila
 
S

SCP

Thankyou. I have over 500 records in the query and only want to merge the
one that I am working on. I could have maybe only 2 quotes to send in any one
month and don't want to go through the process of merging all the records -
just wondered if there was an easier way ?
 
S

Sheila D

You can do this but will have to set some form of criteria in the query or in
Word to identify the records you need. If you don;t want to change the query
that feeds the form, make a copy of it and use that as the mail merge source
modifying the criteria as required.

Hope this helps

Sheila
 
Top