Replace Fields in Outlook Mail

[jamesuk]

Hi All

I found this bit of code that appears to exactly what I need, but I can't get this one bit to work for me. It should be replacing "<< clientname >>" with the value in range A15, but it's not doing it?

Can anyone see a reason as to why it would not be working for me?

Many thanks for your help in advance!

[FONT=Verdana]Sub testing()[/FONT]



[FONT=Verdana]Dim myOlApp As Outlook.Application[/FONT]
[FONT=Verdana]Dim MyItem As Outlook.MailItem[/FONT]

[FONT=Verdana]Set myOlApp = CreateObject("Outlook.Application")[/FONT]
[FONT=Verdana]Set MyItem = myOlApp.CreateItemFromTemplate("\\DATA1\myname$\Desktop\Projects\M\mytemplate.oft")[/FONT]

[FONT=Verdana]With MyItem[/FONT]
[FONT=Verdana]    .To = Worksheets("lookup").Range("A14")[/FONT]
[FONT=Verdana]    .Subject = "Monthly bill"[/FONT]
[FONT=Verdana]    'Refer to and fill in variable items in template[/FONT]
[FONT=Verdana]    .HTMLBody = Replace(.HTMLBody, "<< Clientname >>", Sheets("Lookup").Range("A15"))[/FONT]
[FONT=Verdana]    .Display[/FONT]



[FONT=Verdana]End With[/FONT]

[FONT=Verdana]Set MyItem = Nothing[/FONT]
[FONT=Verdana]Set myOlApp = Nothing[/FONT]


[FONT=Verdana]End Sub[/FONT]

 

[starl]

it's case sensitive. You have shown your field with two different cases - in your text, it's lowercase; in your code, it's initial case. Which is it in your template?

 

[jamesuk]

Hi Starl

Thanks for your response

Sorry, my mistake. in the email template it's,

<< Clientname >>

so both start with upper case

Regards

 

[jamesuk]

I managed to figure it out!

If I take away the

<< >>

and just leave the word, it works fine!

Thank you for your assistance though

 

[Macropod]

Be aware, too, that << Clientname >> is not the same as <<Clientname>>, « Clientname », or «Clientname». Your Replace code is necessarily very particular about what it replaces.

 

[starl]

Hi Paul, I hadn't considered that the brackets may be the wrong ones. Good catch. That's why I prefer using square brackets [] when I do things like that - much easier to find that key on the keyboard (vs memorizing the ALT code)