Brion Appling
asked on
Insert picture with a URL link via mail merge
I am trying to use Mail merge to create email signatures for a client. Most of it is fine, but they have 2 logo images that change based on the person. They also want a custom URL link for each person attached to that image so that when you click on the image, it goes to the personal landing page. I can get Mail merge to insert the link on an existing picture, and I can get the mail merge to insert the custom picture without the link, I just can't figure out how to get mail mert to insert both. I am using O365 version of word, so it is probably 2016. Thanks for your help!
ASKER
Sorry for being absent so long. I had a tech go on vacation and then a couple surprise project pop up on me.
In my data file I have a field that indicates which picture to use, and another field that provides the hyperlink that you should go to when you click on the link.
I can insert the desired picture using the {includepicture"{merge Field}"}
I can also insert the desired hyperlink by using the {hyperlink"{merge Field}""}
What I haven't figured out is how to combine the 2 so that I have a custom picture with a custom hyperlink.
Thanks!
In my data file I have a field that indicates which picture to use, and another field that provides the hyperlink that you should go to when you click on the link.
I can insert the desired picture using the {includepicture"{merge Field}"}
I can also insert the desired hyperlink by using the {hyperlink"{merge Field}""}
What I haven't figured out is how to combine the 2 so that I have a custom picture with a custom hyperlink.
Thanks!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
For example, { HYPERLINK "{ REF goHere }" } will result in creating a hyperlink from whatever is currently defined in the bookmark named "goHere".
If your mail merge had a mergefield named Url, you could use something like this in the merge document:
{ HYPERLINK "{ MERGEFIELD Url }" }
(You'll need to construct the field codes with the braces entered by pressing Ctrl-F9, and not just typing them in.)