mailmerge doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 08 Mar 2005 00:49 GMT

Ok...Hello all...I have a merge document that runs from a macro that keeps
getting hung up in a certain area and was hoping someone might be able to
assist...The line that keeps failing is the line with the stars (****). This
use to work great and now all of a sudden it hangs here or at least that what
it tells me when I go to debug. This is what I have:
Sub MyMacro()
Documents.Open FileName:="S:\Yardi45\3 Day Merge.doc"
With Documents("3 Day Merge.doc").MailMerge
.Destination = wdSendToNewDocument ********
.Execute
End With
Documents("3 Day Merge.doc").Close _
SaveChanges:=wdDoNotSaveChanges
End Sub

Any help whatsoever would be greatly appreaciated.
Thank you,

Signature

Randy Street
Rancho Cucamonga, CA

Reply to this Message

Peter Jamieson - 08 Mar 2005 09:15 GMT

Does your document still have a data source attached? If not, you would
typically get error 5852 requested object is not available at this point
(although I would norally expect you to see an error unless you were using
error trapping with a resume or some such.

Otherwise, have you recently installed any updates to Office?

Peter Jamieson

> Ok...Hello all...I have a merge document that runs from a macro that keeps
> getting hung up in a certain area and was hoping someone might be able to
[quoted text clipped - 15 lines]
> Any help whatsoever would be greatly appreaciated.
> Thank you,

Reply to this Message

Randy - 09 Mar 2005 19:15 GMT

Hi Peter,
yes the data source is still attached. I did recently install Office
SP3...Think that might be the problem?

> Does your document still have a data source attached? If not, you would
> typically get error 5852 requested object is not available at this point
[quoted text clipped - 24 lines]
> > Any help whatsoever would be greatly appreaciated.
> > Thank you,

Reply to this Message

Peter Jamieson - 09 Mar 2005 20:04 GMT

> I did recently install Office
> SP3...Think that might be the problem?

Quite likely. You may need to follow the advice in

http://support.microsoft.com/default.aspx?scid=kb;en-us;825765

Peter Jamieson

> Hi Peter,
> yes the data source is still attached. I did recently install Office
[quoted text clipped - 32 lines]
>> > Any help whatsoever would be greatly appreaciated.
>> > Thank you,

Reply to this Message

Randy - 09 Mar 2005 22:21 GMT

Mr. Jamieson I have two words for you........YOU ROCK! It worked like a
charm! Thank you, thank you, thank you so very much!

> > I did recently install Office
> > SP3...Think that might be the problem?
[quoted text clipped - 41 lines]
> >> > Any help whatsoever would be greatly appreaciated.
> >> > Thank you,

Reply to this Message