sending emails from access through outlook

[sam]

i have 2 problems with sending emails from access through outlook:
1. outlook reports that the email has not been sent even it in sent items
folder.
2. how can i format the email (font, color, align)?

thanks

 

[Arvin Meyer [MVP]]

If it is programmable in Outlook VBA, you can do it from Access by setting a
reference (early binding) or by using late binding. Get the code you need
from an Outlook newsgroup and post it here. An example of Outlook automation
from Access is at:

http://www.datastrat.com/Code/OutlookEmail.txt

You may also want to look at Outlook Redemption to deal with Outlook
security prompts:

http://www.dimastr.com/redemption/

 

[Jason]

I've tried the code: Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
But I get: Compile Error:
User-defined type not defined

Thanks,
J.

 

[Arvin Meyer [MVP]]

Did you set references? You can either set a reference to Outlook in any
code window, which will run the code slightly faster, or you can change the
code from:

Dim objOutlook As Outlook.Application
to:

Dim objOutlook As Object
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Jason]

I have created the reference under tools for Outlook.