On Aug 6, 2:00=A0pm, Carol Grismore
<CarolGrism...@[EMAIL PROTECTED]
> wrote:
> Thank you for your suggestion!
>
> I appreciate (and steal) others' code, and I'm sure this works just
great=
.. =A0
> Actually I think I already have it.
>
> What I'm really trying to find out, though, is how to work the
TransferTe=
xt
> command -- or that it doesn't work, and maybe why.
>
> My bad for not making that clear in my first post.
>
> Thanks again!
> --
> Carol
>
> "pietlin...@[EMAIL PROTECTED]
" wrote:
> > On Aug 6, 12:45 pm, Carol Grismore
> > <CarolGrism...@[EMAIL PROTECTED]
> wrote:
> > > I'm trying to run a very simple TransferText to put data from an
Acce=
ss query
> > > into a Word template. =A0I get the message, "Cannot update.
=A0Databa=
se or object
> > > is read only." =A0
>
> > > To the best of my ability to tell, nothing is read only. =A0Any
debug=
or
> > > repair suggestions would be deeply appreciated.
>
> > > --
> > > Carol
>
> > use Albert Kallal's "Super Easy Word Merge" code. =A0So easy, even *I*
> > can use it.
>
> >http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
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 ActiveDo***ent.MailMerge
.Destination =3D wdSendToPrinter
.SuppressBlankLines =3D True
With .DataSource
.FirstRecord =3D wdDefaultFirstRecord
.LastRecord =3D wdDefaultLastRecord
End With
.Execute Pause:=3DFalse
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 do***ent then continue... but why bother? Just
steal Albert's code, say "thanks Albert!" and on you go....
|
