Highlighted

About data merge and hyperlinks

Community Beginner ,
Mar 21, 2017

Copy link to clipboard

Copied

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!

Adobe Community Professional
Correct answer by Steve Werner | Adobe Community Professional

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.

Views

1.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

About data merge and hyperlinks

Community Beginner ,
Mar 21, 2017

Copy link to clipboard

Copied

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!

Adobe Community Professional
Correct answer by Steve Werner | Adobe Community Professional

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.

Views

1.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Adobe Community Professional ,
Mar 21, 2017

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 21, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Nov 13, 2019

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Kelby LATEST
Community Beginner ,
Jul 03, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...