Mail Merge - Comma delimited data into table

[ocbarney]

Hi There...
I've a got lovely little word merge issue.

I am using an Excel data source - I have many different values entered
in 1 cell, delimited by commas. Looks like this...

Cell1
"String 1", "String 2", "String 3", "String 4"

Is there anyway to Merge this data into a table in Word to make each
field it's own column. I.e., the finished product looking like

Table1
Column1 Column2 Column3 Column 4
String1 String2 String 3 String 4

I've tried using the Convert Text to Table feature but it inserts all
lines into one column of the Table. My data will always contain the
same number of columns and delimiters. Is it possible to accomplish
this with IF Statements? Another way perhaps?

Thanks in advance!
-p

 

[Graham Mayor]

See http://www.gmayor.com/convert_labels_into_mail_merge.htm
The convert text to table module may need you to change the delimiter and
the number of columns. It doesn't always get it right on its own.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[ocbarney]

Thanks for the response.
I have changed the delimiter to comma.
Do you know if Convert Text to Table will work in a mail merge
situation?

Perhaps I could go another route. I know Word doesn't have a Substr
function - but do you know of any other method that would extract
specific values from position X to the first comma?

Thanks for your help
-p

 

[Doug Robbins - Word MVP]

I am not really sure what you are trying to do, but I think you can do what
you want by simply selecting and copying the range of cells in Excel, then
pasting into Word, then select the resulting table and convert it to text,
then select the text and convert it back to a table using comma as the
delimiter.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP