can a form in access be used for a mail merge?

  • Thread starter Thread starter LauraM.
  • Start date Start date
L

LauraM.

I am trying to pull information from a form in access into a mail merge. Is
this possible or does it have to be in a table? There are several fields that
I need on the table that I am not getting to come across, the form seems to
be the obvious way to do it.
 
Forms do not contain any data. They are only windows to view and manipulate
data. To do mail merge, you can use either a table or a query.
 
LauraM. said:
I am trying to pull information from a form in access into a mail merge. Is
this possible or does it have to be in a table? There are several fields
that
I need on the table that I am not getting to come across, the form seems
to
be the obvious way to do it.
Click to expand...

It not clear if you talking about some text boxes that not based on the
table behind the form, but either way, my mail merge sample DOES in fact
pull in the un-bound text boxes + the data from the table into the merge.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.
 
Back
Top