About data merge and hyperlinks

[#1]

Hi! About data merge, is it possible to get the hyperlink (mailto:hi@hello.com) when getting an email address text from .txt?

I mean, I have an Excel file with a column with email addresses: john.doe@hello.com, mary.doe@hello.com, zoe.doe@hello.com...) and I can make a data merge to populate my inDesign file with these email adresses...but I would like to get the hyperlink associated to every email address, too (mailto: john.doe@hello.com).

Is it possible?

Thank you!

[#2]

Hi! About data merge, is it possible to get the hyperlink (mailto:hi@hello.com) when getting an email address text from .txt?

I mean, I have an Excel file with a column with email addresses: john.doe@hello.com, mary.doe@hello.com, zoe.doe@hello.com...) and I can make a data merge to populate my inDesign file with these email adresses...but I would like to get the hyperlink associated to every email address, too (mailto: john.doe@hello.com).

Is it possible?

Thank you!

[#3 · Accepted solution]

I don't think it's possible by using the Data Merge function itself. But after you have created your InDesign data, you can go to the Hyperlinks panel menu (at least in InDesign CC) and choose Convert URLs to Hyperlinks which uses a Search method to find hyperlinks.

[#4]

Thank you very much. I know that feature and it's very helpful but I was also considering another situation: a Column in my database with names and another one with the email asdresses and then display the PDF with the names with the links to the email addresses.

Thank you very much for your quick answer anyway

[#5]

Hi, Have you ever been able to find a solutions to add hyperlinks from database? I have a couple thousand links in a CSV file where the titles themselves shoudl have the hyperlinkns instead of showing the url on a separate line.

[#6]

And still in 2020 desiring a solution or a feature to be added.