Attachment for e-mail

  • Thread starter Thread starter Marco Berardi
  • Start date Start date
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 (e-mail address removed) . 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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
27inc high lumen screen recommendation for Australian Client 0
Office 2010 Pro 1
Why was I just banned for no reason? 2
saving e-mails and attachments 1
Sending mail from outlook using VBA masro 1
Add Attachment to E-mail 2
Extract specific information from the body of outlook mail to an Excel File using VBA 0

Back
Top