I am new to this site and am hoping someone out there will be able to help me. I have already posted this under the VBA section, apologies if this is a bit of a faux pas.
I have several Word 2000 documents that have been set up to mail merge with data in my Access db and I have written a routine to print these documents as an end-of-day routine. This all works fine. My problem is that in some cases I would like to email some of these documents instead and would like to know how (if at all) I can programmatically achieve the equivalent of File > Send To > Mail Recipient in Word and then automatically send it. If possible I would like to avoid just sending an email with a word attachment.
Many thanks in advance for any help you may be able to provide.