Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Comma delimited data into table
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Comma delimited data into table
See http://www.gmayor.com/convert_labels...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 My web site www.gmayor.com Word MVP web site http://word.mvps.org ocbarney wrote: 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Comma delimited data into table
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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge - Comma delimited data into table
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 "ocbarney" wrote in message ups.com... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
Word 2000 mail merge documents won't save Access 2000 data source | Mailmerge | |||
Editing Mail Merge Recipients | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |