Mail merge with macro

[Guest]

Im trying to create a macro which I will run with a command button on my
form. I want to transfer the records currently in view into a mail merge
document that has been pre-designed so that I can use the form to alter the
template for the letter. I have already tried by using a parameter query
(using [Forms]![Form Name]![Record Name]) in correspondance with a macro but
to no avail, could someone give me a somewhat detailed instruction to manage
the desired affect? Any help appreciated

 

[Steve Schapel]

Ron,

The form is based on a query, right? I would use a TransferText action
in the macro to export this query to an 'Export Word Merge' Transfer
Type. And then set up the mail merge document to use this exported file
as its Data Source.

 

[Albert D.Kallal]

To merge the record you are viewing in a form, use my super easy mail
merge...

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

The above is a user solution, and even manages the word templates for you...

Give it a try...you can't go wrong!!

 

[Guest]

Thankyou v.much, thats a perfect answer, I highly recommend your site, its
brilliant

 

[Guest]

I agree! I recommend this site to so many people. One question...on the form,
when I have the choice of my word documents to merge to...how do I get rid of
one of them from the list. I am tyring to make a form as easy as possible and
extra items in that list may lead to confusion.

I would appreciate any help.

Thanks!!!