tab delimiter problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 08 Jun 2007 22:09 GMT

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

Signature

Bryan

Reply to this Message

Cindy M. - 09 Jun 2007 14:30 GMT

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 :-)

Reply to this Message

Bryan - 10 Jun 2007 05:10 GMT

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.

Signature

Bryan

> Hi =?Utf-8?B?QnJ5YW4=?=,
>
[quoted text clipped - 11 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M. - 11 Jun 2007 20:47 GMT

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

Reply to this Message

Rate this thread: