Trying to send a file attachment via Outlook from Access

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I am trying to use a macro (as I dont know VBA) to attach
a given file Eg. Times.mdb to be sent to a given email
address. I have tried SendObject and this is sort of what
I want to do but I want to send a file which contains a
table so that it can be directly used by Access at the
receiving end. Any clues would be greatly appreciated.

Ian
 
Ian,

SendObject is used to send objects that are found within the *current*
database (tables, forms, reports, etc.). If you want to send a file, you
would need to use Outlook Automation which does require a bit of code.
Take a look at the information in the attached link; automating Outlook from
within Access is not really all that difficult!

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/h
tml/office071299.asp
 
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

email attachments 8
Attaching a CSV file to an Outlook Express Email from Access 6
Sending email from access with attachment via Outlook Express6 3
Macro to use information in a cell to locate and send files using outlook 0
sendObject sends too many files 3
Access Manage Attachments linked to a SubForm 0
Allow Access to send email 2
Email more than one table 6

Back
Top