How form button that mail merges the current content

R

Ron

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.
 
D

Douglas J. Steele

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.
 
M

Merge

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>>,

Ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd

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
 
Top