tab delimiter problem

[Bryan]

I'm writing a macro which includes a mailmerge process. Even though my source
file is tab-delimited, I keep getting a prompt for what delimiter I want to
use. Any suggestions on how to avoid this? My code:

With ActiveDocument 'xx
.MailMerge.MainDocumentType = wdFormLetters
.MailMerge.OpenDataSource name:=strWorkFileWithPath,
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=True, PasswordDocument:="",
PasswordTemplate:="", WritePasswordDocument:="", WritePasswordTemplate:="",
Revert:=False, _
Format:=wdOpenFormatAuto, Connection:="", SQLStatement:="",
SQLStatement1:="", SubType:=wdMergeSubTypeOther
.MailMerge.EditMainDocument
End With

 

[Cindy M.]

Hi =?Utf-8?B?QnJ5YW4=?=,

I'm writing a macro which includes a mailmerge process. Even though my source
file is tab-delimited, I keep getting a prompt for what delimiter I want to
use.

What have you used as the record delimiter?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Bryan]

Paragraphs is the record delimiter.

Thanks for your attention, but I believe I've fixed the problem. In the text
I was manipulating, it ended up with too many fields. After I fixed that, the
delimiter prompt seemed to go away.

 

[Cindy M.]

Hi =?Utf-8?B?QnJ5YW4=?=,

Paragraphs is the record delimiter.

Thanks for your attention, but I believe I've fixed the problem. In the text
I was manipulating, it ended up with too many fields. After I fixed that, the
delimiter prompt seemed to go away.

Yes, that would do it, too Glad you tracked it down.

Cindy Meister