printing word form letter thru access

[Matty]

Hi,

I'm creating a form letter in Word which is going to take fields from an Access query. I've got almost all the code worked out, but i've run into a problem. If i was to print the form letter using the PrintOut action, i'm not going to get a print dialog box, right? I want to be able to choose a printer before the letter gets sent. Can i specify that in the PrintOut method? If not, is there any other way i could get a print dialog box to pop up?

 

[jl39775]

Try using the ShellExecute API call.

http://www.allapi.net/apilist/apifunction.php?apifunction=ShellExecute

Hope this helps.

James