Email from Access 2002

[NeilGel]

Hi,

I would like to find out if their is a way to create and send emails from
Microsoft Access? I know there is a way to create an email, but it won't
automatically send?

Also, I am creating numerous text files which are saved into a directory, is
it possible to attached those files to an email using VBA in Access 2002?

Thanks

Neil

 

[Daniel]

You don't mention what you use as an e-mail app (Outlook,...). I'm assuming
Outlook. Take a look at

http://msdn2.microsoft.com/en-us/library/aa159619(office.11).aspx

 

[Tony Toews [MVP]]

I would like to find out if their is a way to create and send emails from
Microsoft Access? I know there is a way to create an email, but it won't
automatically send?

Using Docmd.SendObject and Outlook? That's due to security concerns
so Microsoft added that "feature" to Outlook.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Also, I am creating numerous text files which are saved into a directory, is
it possible to attached those files to an email using VBA in Access 2002?

Yes, but not using SendObject.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[NeilGel]

Thanks for your help, tried the link worked perfect. Apologies for not
including Outlook as my email app.

Thanks alot