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/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"sam" <s...@discussions.microsoft.com> wrote in message
news:382EB411-1976-4F8B...@microsoft.com...

[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]" <arv...@mvps.invalid> wrote in message
news:%23qTX$MAKJH...@TK2MSFTNGP05.phx.gbl...

[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" <Ja...@hotmail.com> wrote in message
news:e7qlBoPK...@TK2MSFTNGP04.phx.gbl...

[Jason]

I have created the reference under tools for Outlook.

"Arvin Meyer [MVP]" <arv...@mvps.invalid> wrote in message

news:uJjZfCVK...@TK2MSFTNGP05.phx.gbl...