Thank you for your suggestion!
I appreciate (and steal) others' code, and I'm sure this works just great..
Actually I think I already have it.
What I'm really trying to find out, though, is how to work the TransferText
command -- or that it doesn't work, and maybe why.
My bad for not making that clear in my first post.
Thanks again!
If it makes you feel any better, if I try to do it they way you
describe, I get the exact same results. Weird!
It does work if I call the Mail Merge from within Word... so you could
automate Word to do it...
Sub RunMerge()
'
' RunMerge Macro
' MailMerge Macro attempt
'
With ActiveDocument.MailMerge
.Destination = wdSendToPrinter
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
End Sub
(that's the code that Word wrote for me.)
so you could declare an instance of Word and run the stuff from
there... open the document then continue... but why bother? Just
steal Albert's code, say "thanks Albert!" and on you go....