Mail Merge - Comma delimited data into table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ocbarney - 15 Aug 2006 01:29 GMT

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

Reply to this Message

Graham Mayor - 15 Aug 2006 07:58 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi There...
> I've a got lovely little word merge issue.
[quoted text clipped - 19 lines]
> Thanks in advance!
> -p

Reply to this Message

ocbarney - 15 Aug 2006 19:23 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 15 Aug 2006 20:12 GMT

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.

Signature

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

> Thanks for the response.
> I have changed the delimiter to comma.
[quoted text clipped - 7 lines]
> Thanks for your help
> -p

Reply to this Message