View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
[email protected] nickbarrar@hotmail.com is offline
external usenet poster
 
Posts: 3
Default How to create an email from mail merge including a hyperlink, so that the value of a merged field is included as part of the hyperlink URL, not just part of its text.

Hi,

I'm working with MS Access 2003 and MS Word 2003 and what I need to
know is how to create an email from mail merge including a hyperlink,
so that the value of a merged field is included as part of the
hyperlink URL, not just part of its text.

The context for this is that I'm trying to create a survey to be sent
out via email, the survey is transactional and thus I need to include
a unique number in the hyperlink included in each email to make it
work, I'm doing this by merging the unique number from access into
the
URL going in the email.

like this:

http://intranet.company.co.uk/custom...asp?ticketid=9...

The "99999" has to be the number from access. I can get it into the
link text - but I can't get it to go in the link URL itself.

If this won't work, is there another way, maybe from the Access end?
Can I generate emails directly from Access?

Any help would be greatly appreciated !

Many Thanks,
Nick