Hi everyone. I'm using the mailmerge feature for the first time as I will need to invite 600 clients to complete an online survey. My company does not allow client contact details to be uploaded to the vendor's system, which would make life much easier.

What I need to include is a unique client name, unique URL for each client (display the link and/or hyperlink to text) and the corresponding sales person's email address in the CC field.



I have tested this quickly and found that i) it does not seem possible to include a CC field, ii) URLs merge and display properly, but are not clickable when received (is this more to do with my email client settings? a lot of people will probably just not bother to copy and paste the link).

Many thanks!

Hyperlink fields for mail merge are a tad tricky, but see http://www.gmayor.com/hyperlink_merge_fields.htm

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Cross-posted at: http://www.mrexcel.com/forum/general...ique-urls.html
For the cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]