Hyperlink target inserted in mail merge
Sil92
-
m@rina Posted messages 27465 Registration date Status Moderator Last intervention -
m@rina Posted messages 27465 Registration date Status Moderator Last intervention -
Hello,
I use Mail Merge to print "template" pages filled with data from an Excel table (nothing complicated...).
But..... in my Excel table I have a "LINK" column that allows me to target PDF files.
I would like the PDF files to be attached to the corresponding "template" pages once the mail merge is printed.
For example usage:
- Sending a letter with a personalized PDF invitation as an attachment
- The personalized invitation being linked by the link in the Excel table
Thank you in advance for your help.
Configuration: Windows / Firefox 62.0
I use Mail Merge to print "template" pages filled with data from an Excel table (nothing complicated...).
But..... in my Excel table I have a "LINK" column that allows me to target PDF files.
I would like the PDF files to be attached to the corresponding "template" pages once the mail merge is printed.
For example usage:
- Sending a letter with a personalized PDF invitation as an attachment
- The personalized invitation being linked by the link in the Excel table
Thank you in advance for your help.
Configuration: Windows / Firefox 62.0
2 answers
-
Hello
You didn't say how you made your Word file.
That being said, the links do not survive the mail merge.
I explain here:
https://faqword.com/index.php/word/publipostage/710-lors-dun-publipostage-les-liens-hypertextes-contenus-dans-le-fichier-source-ne-sont-pas-conserves
m@rina
--
Don't bother asking me your questions privately. I won't answer them. -
Hello,
Thank you for your response. I am familiar with and have followed the tutorial you suggested for Hyperlinks. However, it does not help me with my problem.
The Word file retrieves information from the Excel table in a "standard mail merge" manner. It works very well to produce the sheets with information from the Excel table.
But from your response, I understand that I have no solution to automate attaching the PDF files to the mail merge sheets. I will therefore continue as before, one by one :-).
Thank you again for your time.-
What is possible is to provide a link to this document, following the solution I provided. The recipient will then be able to click on the link to retrieve the document, provided of course that they have the access rights to the location.
However, we indeed cannot embed a document in the mail merge result, if that was the desired solution...
m@rina
-
