Email from excel using VBA - with changing hyperlink in body

[Hitzp2912]

Hi All,

Hoping someone can help. I have set up to email a list of estate agents saying hello, including some performance data and sharing a link to a login page to a platform they use.... this has been done using vba.

However I would also like to send an email to clients. However for the clients to login they need to reset their passwords.

I would like to be able to insert their unique "activation code" as a hyperlink in the body of the email which would take them to the reset password page unique to them.

Id like to do this via the same list as i can lookup the activation codes for clients next to their name in excel.

Hope I have explained this clearly..

Any thoughts?

 

[KOKOSEK]

Use .HTMLBody and then something like:

.HTMLBody = "<a href='www.google.com?activationCode=" & sheets("Codes").range("A1").value & "'>Click here to activate your account</a>"

of course instead of Range("A1").value you will put value of particular code (from list).

 

[Hitzp2912]

Use .HTMLBody and then something like:

.HTMLBody = "<a href='www.google.com?activationCode=" & sheets("Codes").range("A1").value & "'>Click here to activate your account</a>"

of course instead of Range("A1").value you will put value of particular code (from list).

Thanks Kokosek.

However i fear i may not have explained properly... so the Activation Code would be a hyperlink itself as it takes the recipient to their own unique page.

I need a way to get each users hyperlink into the email body.

If im not mistaken the above would take everyone to the same webpage ... but would show them their activation code?