Darshan Hiranandani : How to Open Outlook in HTML Format Using DoCmd.SendObject in Access

[darshanhiranandani24]

Hi everyone,

I’m Darshan Hiranandani, using Microsoft Access to send emails through Outlook with a donor’s tax receipt attached. The email opens in Outlook with the recipient and subject already filled out, but it defaults to plain text format. I would prefer to have the email open in HTML format because my signature includes a logo and other HTML content.

Outlook’s “Compose messages” is set to HTML, so that’s not the issue. I’ve found solutions involving a lot of VBA code, but I’m hoping there’s a simple way to modify the existing code to open the email in HTML format when using the DoCmd.SendObject command.

Here’s the current portion of my VBA code:

'Emails or prints receipt
Dim continue As Integer
continue = MsgBox("Check receipt details before proceeding.", vbOKCancel, "Donor's tax receipt")
If continue = vbOK Then

If Not IsNull(Forms!frmDonorDonation!EmailAddress) Then
DoCmd.SendObject acSendReport, "rptTaxReceipt", acFormatPDF, Forms!frmDonorDonation!EmailAddress, , "bwccr1955@gmail.com", "Tax Receipt Attached"
Else
DoCmd.RunCommand acCmdPrint
End If

Else
Exit Sub
End If


Regards
Darshan Hiranandani

 

[arnelgp]

google "Outlook" automation.

 

[Minty]

This is the second or third time you have asked this:

Darshan Hiranandani : How to Open Outlook in HTML Format Instead of Plain Text via VBA in Access?

Hi everyone, I'm Darshan Hiranandani, working on a simple database for a small non-profit to manage donor information and tax receipts. I'm using the DoCmd.SendObject command in Access to open Outlook with pre-filled TO, SUBJECT, and an attached tax receipt PDF. The issue I'm facing is that...

www.access-programmers.co.uk

This thread answers you question.

Emmanuel Katto : How to Set Outlook to Open in HTML Format from Access Email

Hi all, I’m Emmanuel Katto, working on a small database for a non-profit that tracks donors and their donations. I’ve set up an Access form that, using the DoCmd.SendObject command, opens Outlook with a filled-out email, including an attached tax receipt. However, the problem is that Outlook...

www.access-programmers.co.uk

And the answer won't change, if you ever look at any of the answers provided.

 

[arnelgp]