Skip to main content
Participant
Apr 1, 2025 11:34 PM UTC
Question

Formatting Large List of Names & Addresses

Hi All,

 

Trying to format a very large list of company names, addresses and phone numbers into my ID doc. Other than setting up Character Styles and formatting each company separately is there a quicker way?

4 replies

James Gifford—NitroPress
Legend
Apr 2, 2025 12:47 AM UTC

If the list is very regular, you could use GREP and next-style to do a first formatting pass.

 

I'm sure a script could be developed as well. My approach, though, would probably be to use Word and some on the fly macros to apply styles, then import.

Translate
Robert at ID-Tasker
Legend
Apr 2, 2025 12:09 AM UTC

@Launch Design

 

Import / place this list as TABLE - otherwise, you're in big trouble. 

 

To each column - apply dedicated ParaStyle. 

 

Convert this table to text - with both separators as "paragraph". 

 

Run Text  Find&Change - "^p^p" -> "^p".

 

Translate
Inspiring
Apr 1, 2025 11:42 PM UTC

What is the source of the VLL? If it is in spreadsheet you might start with a data merge and then thread all the resulting frames. Apply char styles during data merge setup.

Translate
Robert at ID-Tasker
Legend
Apr 2, 2025 12:13 AM UTC

@Zealous_work5E55

 

DataMerge makes sense ONLY if you've graphic elements - images or QR codes. 

 

Or extremely, EXTREMELY convoluted design. 

 

There is no conditional importing so in case of a "plain text" - DM doesn't bring any value. 

 

Translate