E-mail from Access to Outlook

[Guest]

I have a CMD Btn that I use that generates a email to the email address on the form and it also puts message text in the email. I use the DoCmd.SendObject and it works great

Now the rest of the story. When the email come up I must click the Options btn so that I can tag the message for a Delivery Receipt and Read Receipt and then close the Options Menu and then send the email

I know this sound lassie but after doing 100 emails it would be faster

NOTE: I have clicked the default in outlook but I still nees to click them if the email is generated from Access

Can I use code to do this for the end user??

 

[Cheryl Fischer]

AFAIK, those options are not available with SendObject. You might want to
investigate using Automation with Outlook. There is sample code at the
following links that can get you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I have a CMD Btn that I use that generates a email to the email address on

the form and it also puts message text in the email. I use the
DoCmd.SendObject and it works great.

Now the rest of the story. When the email come up I must click the Options

btn so that I can tag the message for a Delivery Receipt and Read Receipt
and then close the Options Menu and then send the email.

I know this sound lassie but after doing 100 emails it would be faster.

NOTE: I have clicked the default in outlook but I still nees to click them

if the email is generated from Access.