e-mail from access

[Fio Koller]

I would like to start an e-mail directrly from my db by pushing a button
beside the e-mail address

thanks for your hints

Fio

 

[Arvin Meyer]

Look at the SendObject Method in the help files, or if you are using
Outlook, you can also visit my website and download free code:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tony Toews]

I would like to start an e-mail directrly from my db by pushing a button
beside the e-mail address

You can also visit the Access Email FAQ at my website.

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

 

[Fio Koller]

Sorry, I'm such a beginner!
First I produced an error with OutlookEmail.txt
then I activated Microsoft Outlook 10.0 Object Library

Your codes now works without error but the file somehow will not be sent.
Is it because I need to activate another library?

After this code
Set objEmail = objOutlook.CreateItem(olMailItem)

it shows objEmail = ""
empty, right?

Thanks again for any hint

Fio

 

[Arvin Meyer]

If you step through the code a bit farther, you'll find that objEmail takes
the value of the .Subject string. The only way I've found to break the code
is to not be logged in under the default profile for Outlook and have
Outlook closed. If Outlook is open, it has always worked for me.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tim Cali]

It worked for me. If you don't have Outlook open, you won't see anything;
the app is not visible.

Did you check your Outlook Sent items?

After this code
Set objEmail = objOutlook.CreateItem(olMailItem)

it shows objEmail = ""
empty, right?

Good, so in the Debug window type in:

?typename(objEmail)
and then hit Enter

You should see MailItem, which indicates that the code is working.

 

[Fio Koller]

Thanks a lot. This works perfectly now! I had to install Outlook first.