automating an outlook template to send an email to a selected recipient

[LondonJohn]

thread181-459711
I have an Access 2003 database and when the user clicks on an email address (hyperlink field) in a selected record, I want it to automatically open the outlook template I have created and append the email address.
Can I do this with some simple VBA code?

Thank you

LondonJohn

 

[1DMF]

Have you looked at :-

https://msdn.microsoft.com/en-us/library/office/ff865637.aspx

CreateItemFromTemplate("C:\My\Path\MyTemplate.oft")

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music