How form button that mail merges the current content

Ive made an access database and form sucessfully and I want to create a
button on my form that will transfer the current form's content into a
pre-designed word document via mail merge. How can I make a mail merge
without hundreds of names, just with the name that I want to create a letter
to that is listed in the form. I don't want to have to use mail merge to
transfer my whole access database that I must go through just to find the one
template that I actually require. Any possible help to achieve this or even
to get close would be very helpful.

Create a query that returns only the current name (make a parameter query
that gets the parameter value from the form), and merge the query, not the
table.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ron" wrote in message
...
Ive made an access database and form sucessfully and I want to create a
button on my form that will transfer the current form's content into a
pre-designed word document via mail merge. How can I make a mail merge
without hundreds of names, just with the name that I want to create a
letter
to that is listed in the form. I don't want to have to use mail merge to
transfer my whole access database that I must go through just to find the
one
template that I actually require. Any possible help to achieve this or
even
to get close would be very helpful.

ROn I'm looking to do something similar I have a sub form attached, Did you
enter in the form a standard letter in a text box?

ABC Corp
Xxxx
Xxxx
Xxx

Dear VENDOR,

Dddddddddddddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddddddddddddd ddddddddddddddddddddddddddddddddddddddddd

Sincerely
BLAH
BLAH
BLAH
BLAH


Material Code Material Description
Material Code Material Description
I want to have the letter look like this but only the form wil group any
multiple items that have the material code and decriptions. I created a form
that right now just has the vendor main form and the material info as the
subform.

thanks debbie


"Ron" wrote:

Ive made an access database and form sucessfully and I want to create a
button on my form that will transfer the current form's content into a
pre-designed word document via mail merge. How can I make a mail merge
without hundreds of names, just with the name that I want to create a letter
to that is listed in the form. I don't want to have to use mail merge to
transfer my whole access database that I must go through just to find the one
template that I actually require. Any possible help to achieve this or even
to get close would be very helpful.