Skip to main content
Participant
April 1, 2025
Question

Formatting Large List of Names & Addresses

  • April 1, 2025
  • 3 replies
  • 235 views

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?

3 replies

James Gifford—NitroPress
Legend
April 2, 2025

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.

Robert at ID-Tasker
Legend
April 2, 2025

@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".

 

Inspiring
April 1, 2025

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.

Robert at ID-Tasker
Legend
April 2, 2025

@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.