Attachment for e-mail

M

Marco Berardi

Hi all,

my program in MS Access creates every day a text file called TRASM.TXT.
At the end I have to attach this file to my e-mail client and send a
message to [email protected] . I'd like to create a button that automatically
attaches the file to the client ready to be sent. After that I could
close my program and finish the job directly from the e-mail.

I thought I could use Docmd.SendObject but I had to give up. Do you
have any suggestion?

Thanks

Marco
 
V

Vincent Johns

Marco,

Perhaps your problem with SendObject was that your "object" (your
TRASM.TXT text file) was not an object inside your database (such as a
Table or Query).

Instead of (or in addition to) creating a text file, could your Access
program create a Report or Table containing the same information? Then
I think you could use SendObject.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Top