Creating and sending e-mail with attached files from Access 2003!

[Niklas Östergren]

Hi!

Is it possible to create a e-mail msg with attached files (*.txt, *.doc,
*.xls, *.jpeg etc.) and send it from Access 2003?

I have looked into <DoCmd.SendObject> but this method only supports sending
Access objects as attached files.

I have also, sometime ago, seen some code for creating a e-mail msg using
references to Microsoft Outlook, but it´s a while ago and I can´t remember
how to use it. And I don´t know if it´s possible to attache files using this
method (logicaly it has to be possible though).

Any help are appreciated!

TIA!
// Niklas

 

[Niklas Östergren]

Forget about this msg.

I have solved it by setting reference to Microsoft Outlook and using method:

CreateItem(olMailItem)

This works just fine and is what I need. After a little bit testing I got it
to work with help of the helpfile (YES! ).

// Niklas

 

[Tony Toews]

Forget about this msg.

I have solved it by setting reference to Microsoft Outlook and using method:

CreateItem(olMailItem)

This works just fine and is what I need. After a little bit testing I got it
to work with help of the helpfile (YES! ).

Glad you figured it out yourself. For the future though Microsoft
Access Email FAQ
http://www.granite.ab.ca/access/email.htm

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

 

[Niklas Östergren]

Hi Tony!

Thank´s for the link to the FAQ site!

Right now I´m a little bit to tired to read throug what´s avaliable there.
But I´ll do it tomorrow though.

// Niklas