dynamic hyperlink wtih merge

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Dynamic hyperlink wtih merge field

Dynamic hyperlink wtih merge field

resolvedResolved · High Priority · Version 2013

Rowena has attended:
Outlook Advanced course
Excel Advanced course

Dynamic hyperlink wtih merge field

Is it possible to create a hyperlink containing a merge field?

I am using the same hyperlink but need to insert a merge field at the end so that it picks up a specific code to direct people to a personalised web page.

I can insert the link with the mail merge directly into the document (which works) but I want to change the text that is displayed and it won't allow me to do that.


Thank you

RE: Dynamic hyperlink wtih merge field

Hi Rowena

When you insert the link using mail merge, does it act like a hyperlink or only view as one?

Kind regards,
Wendy

RE: Dynamic hyperlink wtih merge field

Hi Wendy

It is viewing as a hyperlink but not acting as one. It's the mail merge part that is not being included in the hyperlink.

http://www.gold.ac.uk/welcome/enrolment/timetable/?programme= «Cohort_Reference»

So when I do the mail merge the merge field doesn't work and the above link only works up to the equals symbol.

Thank you
Rowena

RE: Dynamic hyperlink wtih merge field

HI Rowena

You may have to use some VBA to convert it into a hyperlink. Or copy and paste the link as text and not fields.

Unfortunately it won't just turn it into a hyperlink by adding the merge field to the end. It will require a bit more work after that.

Have you worked with VBA or Macros in either Word or Excel previously?

Kind regards
Wendy

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

Check The Text Style Used

For people who use styles there is a quick way of checking which style has been used on text.

Press Shift-F1. The cursor turns to a question mark and pointer.

Click in the text you want to know about and Word opens the 'Reveal Formatting' task pane showing all the information on the style (its font, formatting and so on).

View all Word hints and tips


Server loaded in 0.08 secs.

✓ w3speedster