How do I create a macro to open/run WordMailMerge option from Acce

[Guest]

I need simple step-by-step instructions to create a macro that will open and
run WordMailMerge option from MS Access 2002 database. I have created the
database, table, and mail merge documents and just need the right actions in
the right order to automate the process.

 

[Steve Schapel]

Amanda,

I believe this will be difficult to achieve with a macro. If you have a
Word document that is set to use an Access table as its Data Source,
then you simply need to open the Word document and the merge should be
automatic. If taht's the case, you can use the RunApp action in a macro
to open the Word document. However, if your requirement is more complex
than that, then controlling Word from within Access is stretching the
capability of macros. I think you will be better to look into Office
Automation using VBA procedure. Having said that, you might like to
have a look at the "Simple Word Merge" section on this page:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

You mention running the App in a macro. I know how to RunApp to Open
Microsoft Word, but how do I make it open the specific .rtf files I have
stored. Even this procedure from a macro would be sufficient at this point.

 

[Steve Schapel]

cmiller,

The Command Line argument of the RunApp action in your macro would look
something like this:

"C:\Program Files\Microsoft Office\Winword.exe" "C:\YourFolder\YourFile.rtf"