Auto Fill Outlook template (1 Viewer)

[stu_c]

Hi all
I have a default Email template, I would like to create something in VBA that loads up the Email template, fills out the subject with data from the access form and also inputs data into a certain bookmark section is this possible?

 

[theDBguy]

I think so. Here's one piece of it.

Application.CreateItemFromTemplate method (Outlook)

Office VBA reference topic

learn.microsoft.com

 

[stu_c]

Hello
I have managed to get the template to open and input the subject automaticallyjust struggling to get the bookmarks to work

Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItemFromTemplate("C:\statusrep.oft")
MyItem.Subject = "Status Report"
MyItem.display

I tried
Set bm = oDoc.Bookmarks("BMCustomerName")
bm.Range.Text = "TESTABC"
oWd.Visible = True