Hi
I've written some code based on Ron de Bruin's example of creating a mail item to send, but I changed it to open an outlook template instead. Everything works fine, except that I can't get the .body = replace line to do anything - it doesn't error, it just does nothing at all. I was wondering if anyone can see why this is? I want it to find the "<< contact >>" in the testtemplate.oft and replace it with the value from the specified sheet/cell.
Code:
I'm sure it's a simple thing that I'm overlooking. I'm just not that good with the old VB is all.
Any help greatly appreciated.
Cheers
rbbr
Bookmarks