Lettermerge problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Per H. Jensen - 22 Jun 2005 09:05 GMT

I am using Word 2003 and a CSV data source to create a mailmerge. Amongst the
data elements is a field that contains an element in the format
12345678-9878. This item has to merged into 2 different fields, where the
first merge field has to show the first 8 numbers before the "-" and the
second merge field has to show the last 4 numbers after the "-". Is this
feasible, and if so how. I have checked the online help and simply cant find
anything that helps me do this.

Changing the original CSV file content is NOT an option.

Thanks in advance.

Signature

Best regards
Per H. Jensen

Reply to this Message

Doug Robbins - 22 Jun 2005 18:10 GMT

I think that you have a couple of choices. One would be to open the CSV
file in Excel and use a formula to split the element into two, then use the
Excel file as the data source.

Another would be to use a Catalog or Directory type mailmerge to create a
Word document containing the data and then use a macro to do the splitting

Or, execute the merge from the CSV file with a placeholder for one part of
the data and then run a macro over the document to split the element and
replace the placeholder with the relevant part of the data.

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

>I am using Word 2003 and a CSV data source to create a mailmerge. Amongst
>the
[quoted text clipped - 9 lines]
>
> Thanks in advance.

Reply to this Message