e-mail from access

  • Thread starter Thread starter Fio Koller
  • Start date Start date
F

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
 
Fio Koller said:
I would like to start an e-mail directrly from my db by pushing a button
beside the e-mail address
Click to expand...

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
 
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
 
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
 
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?
Click to expand...

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.
 
Back
Top