Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Specifying merge field delimiter
Message
From
24/01/2007 09:39:52
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, United States
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01188419
Message ID:
01188640
Views:
13
Hi Yuri,
The problem is that I want to embed tabs and CRLF in one of the merge fields in order to simulate a table of five columns. If I have to, I'll drop mail merge and "hand build" each letter at run time and build the table, but I'd love to keep it a simple mail merge.

It's inconceivable to me that MS would allow us to specify a number of delimiters through the interface but not have a way through the API but it wouldn't be the first brick wall from Word.

Thanks,
Gary

>>Hi,
>>I have a merge routine using a txt file with |(pipe) for the field and ^ for the record delimiters. Odd choices I know, but Word allows them. However, at merge time Word asks for the delimiters. When these are picked, the merge works fine but I want to tell Word what to use instead of getting the dialog.
>>
>>Anyone know how to tell Word what the delimiters are?
>>
>>Thanks,
>>Gary
>
>Probably the easiest way would be to convert delimeters/separators to the "standard" characters, like:
>
>strtofile(CHRTRAN(FILETOSTR(original_txtfile),[|^],["]+CHR(13))),temp_txtfile)
>
>And then you may use the temp_txtfile as a data source for the mailmerge.
Previous
Reply
Map
View

Click here to load this message in the networking platform