Tricky one, printing Word mail merge from form button.

[mr_sd]

Hi, heres my problem:

I have a database which prints letters.

I have a word document which prints the envelopes via a mail merge from the database.

I would like to know if there is any code I could use on a button which will automatically merge the 'envelopes' document to the printer rather than opening it and clicking "merge to printer".

Ideally, it would open the word doc, print the envelopes and close the word doc as quickly as possible

So far, I have established the quickest way of opening the word doc is using the FollowHyperlink command

Sound a bit pointless, I know, but you'd be surprised how computer illiterate some of my staff are!

Thanks in advance,
Rich.

 

[mr_sd]

Anyone?

 

[mr_sd]

Just realised something really obvious

Why don't I just make a report for the envelopes instead of a word mail merge?!?

*Slaps Self*

Sorry guys.