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

dynamic hyperlink wtih merge

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

Dynamic hyperlink wtih merge field

ResolvedVersion 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:

Printing specific sections of your document

If your Word document contains sections and you want to print one specific section, you can do so by going to File - Page Setup, then entering the number of the section preceded with an 's' in the Pages box (e.g. entering s2 in the Pages box would print just section 2). Then click OK to print.

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.