View original (French)

Mail merge Excel Word with HYPERLINK link

EDI9366 Posted messages 3 Status Member -  
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   -

Hello,

I have a mail merge to do via email with Outlook with a personalized link for each send.

My problem is that my URL during the mail merge remains fixed to the first line of my Excel database.

I have followed quite a few tutorials I found on Google, but I haven't found anything to solve my problem.

I am attaching a link below to my Google Drive to share my test Excel database and my Word file so that you can better understand.

https://drive.google.com/drive/folders/1ETOOOUQaYQo3wABMEBxhIaqbxpvrntMg?usp=sharing

Thank you for your help.


Eddie

2 answers

Answer 1 / 2
m@rina Posted messages 27378 Registration date   Status Moderator Last intervention   11 561
 

Hello,

You did not insert the Url field in your HYPERLINK, like this:

Don’t forget, once the merge is done, to update the links, as I explain here:

https://faqword.com/index.php/word/19-publipostage/710-lors-dun-publipostage-les-liens-hypertextes-contenus-dans-le-fichier-source-ne-sont-pas-conserves

m@rina
0
Answer 2 / 2
EDI9366 Posted messages 3 Status Member
 

I feel like there is no solution to this problem with the Office solution.

For my part, in the end, I went through Google Sheets and installed an extension called "YAMM" which allows for mail merge with Gmail/Google Sheets and keeps the clickable hyperlink links.
-1