Is there any way to export text that has multiple lines for each record? I’d like to export a text file which resembles address labels, for example:
John J. Jones
123 Main St.
Anytown, MA 02111
Mary B. Smith
456 Second St.
I’ve been unsuccessful in getting the Text Export Wizard to do this. No matter what I enter into the formula bar, I always get one line of text for each record.
I know that I could enter dummy characters (for example $$) instead of the line break, so that the exported file would read:
John J. Jones$$123 Main St.$$Anytown, MA 02111
Then I could use my word processor to find-and-replace $$ with paragraph breaks. But I’d like to avoid that extra step if possible.
Thanks for any tips you can offer.