Formatting Large List of Names & Addresses

[Launch Design]

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?

[Zealous_work5E55]

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]

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

[Robert at ID-Tasker]

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

[James Gifford—NitroPress]

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.