Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

macro for mail merge report

Status
Not open for further replies.

homeless

Programmer
Nov 6, 2001
20
CH
Could anyone tell me how to create a macro to open a mail merge report? I created a data entry form and used mail merge to get a report. Everytime when I use data entry form, I have to open Word first then Access form. After I finished data entry, I needed to save the form, copy a account # and go back to Word. Then used the account # to find the report in Word. It was very complex. Now I want to create a command button carrying macros or qureys in the data entry form. So I can just click the buttom after I finish data input, and the mail merge report will come out. How can I do? I don't know any progamming. Thank you for any help.
 
Take a look at my FAQ's
Mail Merge to Word using Access query and form
faq181-271

Shell to Word, Open a Doc and run a Macro
faq181-28 DougP, MCP

Visit my WEB site to see how Bar-codes can help you be more productive
 
After I read FAQ181-28 and FAQ181-271, I wonder how to create a query whose criteria is looking at the form and can have other tables.The Word doc then mail merges to that query. What is [uniquefieldname]? Is it a primary key name? Such as Account #.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top