Ah. Way too deep for me - sorry i really don't understand anything in that
answer
> Ah. Way too deep for me - sorry i really don't understand anything in
> that
> answer
I hoped you might at least understand stuff such as
>> a. the Excel document might be corrupt
>> b. the Excel document might be very large
and be able to set up some simple tests that might reveal problems in those
areas (e.g. experiment using a newly-created, small, definitely not corrupt
Excel file as the data source)
but let's look at this a different way.
At the moment, the user opens the document (is that just using Word
File|Open, or what?). Then she sometimes sees the error.
If she sees the error, she can disconnect, then reconnect, and it then works
(I think - is that correct?).
After that, has she saved the Mail Merge Main Document? If not, can she do
that and see if that makes a difference (I don't see why it should, but it
is the first thing to try).
Finally, can you spell out what you meant by:
>> > (it failed when she logged into my machine)
?
Peter Jamieson
> Ah. Way too deep for me - sorry i really don't understand anything in
> that
[quoted text clipped - 113 lines]
>> >> >
>> >> > Chris
havenlad - 12 Jul 2006 14:38 GMT
Thanks for your patience
I did understand those basic parts, but the Macro parts are way too deep.
There are a few spreadsheets they use for the mail merges. The problem
occurs with several of them, not just one. They vary in size. I will ask
her to copy and paste the excel file to another location and copy and paste
it back to the original location and will ak they do this each time it
happens for a few days at least.
I will ask her to try the things suggested.
Spot on about the reconnect.
She logged into my machine with her account and tried the mail merge from
there. The problem followed, which rules out a problem on her machine. A
colleqgue then logged in on his machine and the same thing happened to him,
so it's not a machine or account problem
Hope this helps
> > Ah. Way too deep for me - sorry i really don't understand anything in
> > that
[quoted text clipped - 144 lines]
> >> >> >
> >> >> > Chris
Peter Jamieson - 12 Jul 2006 17:54 GMT
> I did understand those basic parts, but the Macro parts are way too deep.
Understood.
Let's see how things go.
Peter Jamieson
> Thanks for your patience
>
[quoted text clipped - 180 lines]
>> >> >> >
>> >> >> > Chris