tab delimiter problem Bryan 6/8/2007 9:09:03 PM 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 -- Bryan

Re: tab delimiter problem Cindy M. <C.Meister-C[ at ]hispeed.ch> 6/9/2007 1:30:46 PM Hi =?Utf-8?B?QnJ5YW4=?=, [Quoted Text] > 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 :-)

Re: tab delimiter problem Bryan 6/10/2007 4:10:06 AM 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. -- Bryan "Cindy M." wrote: [Quoted Text] > 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 :-) > >

Re: tab delimiter problem Cindy M. <C.Meister-C[ at ]hispeed.ch> 6/11/2007 7:47:35 PM Hi =?Utf-8?B?QnJ5YW4=?=, [Quoted Text] > 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