mail merge in publisher using txt data source

C

chili

I am trying to merge an excel data source to publisher including various
formatting (letters, percentages, numbers). In this case: column 1 'name of
firm', column 2 'sales', column 3 'profitability' etc. To preserve the
formatting (decimals, % etc.), I saved the excel as a txt-file (using tab as
separator). Problem! When merging, the tab does not work as a separator.
Instead, it reads as if all the columns were one and the same and thus only
one possible merge field appears per row with all the information (i.e. <firm
sales prof...>). Using semi-colon (;) works except that for the one column
that starts with zeros for the first 10 or so observations, comes out as all
zeros when merged.

Please help!!!! Getting my publisher 2003 to identify the tab as a separator
in the txt file would really make my life easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top