mailmerge from Access

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

Hi, Totally confused trying to sort this out. I want to produce a
straightforward Word letter mailmerged with salutation and address details,
all held in a Table. Searching the forums appears to indiccate that you
should extract the required fields in a Report ?
I've produced a report from the Table, but it also includes unwanted
Records, i.e. incomplete addresses that I obviously want to filter out.
I seem unable to filter the report directly, but have to produce a Form, and
filter that in order to produce the required clean data, so far OK.
However when setting up the Word document it will only enable you to import
data from a Table or a Query ? Access wont let you produce a Query or a
Report from the filtered Form.
How should I go about extracting the filtered fields I need from my original
Table, preferably from my filtred Form, to get them merged into a Word
document ?
 
set up a query that returns the values that you want....

then from Word - make the data source for the merged document to be this query
 
I have a nice working sample that does a merge of the current record to
word.

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