Controlling Outlook from Access VBA

Topic

New Reply

Hello All,

I have the following code:

Code:

       Set miMail = appOL.CreateItem(olMailItem)
       With miMail
           .To = rst![EMail]
           .Subject = "WPOA Annual Dues Statement: " & rst![OwnerLName]
           .Body = zMsgBody & "Bill" & Trim(Str(rst![OwnerID])) & _
                   " Owner: " & rst![OwnerLName]
           .ReadReceiptRequested = True
           zAttFN = zBillPath & "Bill" & _
                    Trim(Str(rst![OwnerID])) & ".pdf"
           Set oMyAtt = miMail.Attachments.Add(zAttFN)
           .Save
       End With   'miMail

       Set miMail = Nothing

That is working just fine. I would like to add to it to create the email with an existing Stationary. I’ve searched but can’t find a property or method to handle this. Any Ideas?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Replies

I would like to add to it to create the email with an existing Stationary. I’ve searched but can’t find a property or method to handle this. Any Ideas?

Probably easiest to create a new message using your stationery and save it as an OFT file, then use the CreateItemFromTemplate() method.

Reply | Quote

Jefferson,

I found thison the MSDN site. However, I have a sample of the stationary already in Outlook I created a new email with it and tried to save it as an .OFT file but there is no option to do so on the Filetype dropdown in Outlook 2003 using Word as my Email editor. The stationary is basically a letterhead with text and a graphic. So how do I get this existing stationary saved as an .OFT file?

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

I created a new email with it and tried to save it as an .OFT file but there is no option to do so on the Filetype dropdown in Outlook 2003 using Word as my Email editor.

Uhhhhh…. that is a scenario I have not explored. Perhaps when Word is your editor there is some other preferred format???

Reply | Quote