Is there a way to set the record Delimiter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 14 Apr 2004 20:04 GMT

I want to change the record Delimiter in a mail merge in
word. I know if I change it in my datasource file and
open it with the MailMerge.OpenDataSource command in VB it
puts up the Dialog Titled "Header Record Delimiters"
asking me to change the Field and Record Delimiters. Can
I set these two Delimiters in Word 2000 or greater before
I call the MailMerge.OpenDataSource in vb so the dialog
will not show up? This is an issue for me because one of
my field need to contain a cr and a lf in it. I tried
putting the cr and lf inside quotes. That work except that
the quotes also showed up in the merged doc

Example
Public Sub AddCCToList(sCC As String)
If (Len(msCCList) > 0) Then
msCCList = msCCList & Chr(34) & Chr(13) & Chr(10)
& Chr(34) & sCC
Else
msCCList = sCC
End If
End Sub

Gave me the results

Jim Hays"
"Greg Scott

thanks

Mike

Reply to this Message

Peter Jamieson - 14 Apr 2004 21:12 GMT

I don't think there is a way, at least not directly. It's possible to set
the field delimiter (and it may be possible to set the "text delimiter" for
ODBC connections using entries in a SCHEMA.INI file, but as far as I know
ODBC relies on the record delmiter being CRLF.

> This is an issue for me because one of
> my field need to contain a cr and a lf in it. I tried
> putting the cr and lf inside quotes.

Are you just putting the CR and/or LF inside quotes, or the entire field?

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I want to change the record Delimiter in a mail merge in
> word. I know if I change it in my datasource file and
[quoted text clipped - 26 lines]
>
> Mike

Reply to this Message

- 14 Apr 2004 22:03 GMT

I am not using ODBC, I am passing a path to a file in the
MailMerge.OpenDataSource call. If I can't change the
record delimiter then what is wrong with the way I am
using the quotes to tell Word Merge to skip over the CRLF?
Why does it show the quotes in the merged doc?

Mike

>-----Original Message-----
>I don't think there is a way, at least not directly. It's possible to set
[quoted text clipped - 39 lines]
>
>.

Reply to this Message

Peter Jamieson - 15 Apr 2004 08:23 GMT

Just quoting the carriage returns isn't going to work.

Quoting the entire field with carrage returns might work, but I wouldn't
guarantee it.

e.g. if your record contains

field1,field2line1
field2line2,field3

you have

field1,field2line1"
"field2line2,field3

butyou probably need

field1,"field2line1
field2line2",field3

Signature

Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I am not using ODBC, I am passing a path to a file in the
> MailMerge.OpenDataSource call. If I can't change the
[quoted text clipped - 58 lines]
> >
> >.

Reply to this Message

- 15 Apr 2004 19:19 GMT

Peter

Putting Quotes around the whole field worked.

Thanks

Mike

>-----Original Message-----
>Just quoting the carriage returns isn't going to work.
[quoted text clipped - 81 lines]
>
>.

Reply to this Message

Rate this thread: