Trying to send a file attachment via Outlook from Access

[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

 

[Cheryl Fischer]

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