Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Help send word doc as email with Access 2000

Hello,

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.

Regards,

Paul G

Comments

  • pdgloverpdglover Member Posts: 3
    I have found an answer to my problem so please ignore this thread.

    If anyone out there needs help to automatically send a word document from Access please visit http://word.mvps.org/FAQs/InterDev/SendMail.htm. Please believe me when I say theres not much readily available info out there to do it. Once I've tidied all the code up I'll post it here as an example of automatically mail merging and emailing a word document.

    Regards

    Paul G



Sign In or Register to comment.