Send email from Access (2003)

Topic

New Reply

Hi,

I am using the attached SendMail codes from Hans in my Access database to convert report to a pdf file and then attach a new mail as attachement.

I would like to know if I can update it to have outlook send me a receipt emai, mark it as important and turn flag for follow up for due by 3 days later.

SendMail “to@to.com”, “cc@cc.com”, “”, strTopic, strMBody, strPDFFile, ShowMail:=True

Thanks in advance.

Regards

Reply | Quote

Replies

These are Outlook questions, not Access questions.

Please look up the MailItem object in the Outlook VBA help. There are properties for these settings. In your code, you’d set these properties for the objMI object before displaying or sending it.

For example, you can set

.ReadReceiptRequested = True
.Importance = olImportanceHigh
.FlagStatus = olFlagMarked
.FlagDueBy = Date + 3

Reply | Quote

Thanks, Hans.

After I apply the codes, is those seting going to affect to all the email that I send from Outlook or just only the email I open from Access database?

Thanks

Regards

Reply | Quote

The settings I mentioned in my previous reply only apply to the e-mail being created by the code, not to Outlook in general.

Reply | Quote

Thanks, Hans.

Is there anyway to auto open the “To” box as a new email open?

Reply | Quote

Sorry, I don’t understand your question.

Reply | Quote

I would like to know if I can update it to have outlook have “To” box open, so user can type name and select from Global Address List.

Thanks

Reply | Quote

The user can click on To… or press Alt+. to open the dialog. I would find it irritating if the dialog was displayed automatically. But if you really want to do it, you might add a line

SendKeys "%."

below the line with .Display.

Reply | Quote

Thanks, Hans.

Reply | Quote