Adding an Attachment to an Email sent by Access 1

[rokerij]

Refer to thread703-816550

We now are sending reports via email through Access. My question is there a way to attach another attachment, say a word document to the same email with little or no interaction from end user?

Thanks in advance!

Shane

S.C. Albertin
Systems Coordinator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...

 

[KenReay]

Hi

Presumably you are using DoCmd.OutputTo to send the EMails?

Look at automating Outlook to do it, then uou can add attachments, see CreateObject()/ GetObject() in help for examples

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[rokerij]

Thanks for that, and you were presuming right, we are in fact using the DoCmd.Output to create the file. A star for you. I have it working

S.C. Albertin
Systems Coordinator/Newbie Tech
United Way

Help me to find my way, so that I may help others find theirs...