How to email attached files

[ericb]

I need to send an email with attached files (not the data type). Within
access I would like to send an email with 2 or 3 extra files.

I am unable to send extra files with the DoCmd.SendObject function.

Those somebody have a suggestion.

Thank you

 

[Wayne-I-M]

Hi

Have a look at this

http://groups.google.com/group/micr...endobject+wayne+group:microsoft.public.access

 

[bekkai lbarkani]

I need to send an email with attached files (not the data type). Within
access I would like to send an email with 2 or 3 extra files.

I am unable to send extra files with the DoCmd.SendObject function.

Those somebody have a suggestion.

Thank you

 

[Marco Pagliero]

I need to send an email with attached files (not the data type). Within
access I would like to send an email with 2 or 3 extra files.

I am unable to send extra files with the  DoCmd.SendObject function.

Yes, sendObject cannot do that.
Automation is the way, here how to do this (third and fourth
message).
http://www.tek-tips.com/viewthread.cfm?qid=1041461&page=5

You notice that you can execute several
..Attachments.Add "c:\something.txt"
inside a loop, one for every attachment.
If you write
..Send
instead of
..Display
it sends the mail directly.

Greetings
Marco P