Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Outlook save attachments problem (http://www.outlookbanter.com/outlook-vba/18472-outlook-save-attachments-problem.html)

Justin June 21st 06 06:29 AM

Outlook save attachments problem
 
Hi All,

I have an issue with one of my users in relation to some code that gets run
in outlook. Basically the code reads the subject line and then saves the
attachment to the "c:\temp\" directory on the users machine. The problem is
that the code will work flawlessly on any other machine - ie it will save an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it has saved
the file, but when you check it is not there. I could run the code 100 times
a day and it will work 92 times without an issue and the file is saved in the
temp directory, the other 8 times it will not be there. I can trap the error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just happens.

TIA

Justin

Dmitry Streblechenko June 21st 06 05:30 PM

Outlook save attachments problem
 
Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that gets
run
in outlook. Basically the code reads the subject line and then saves the
attachment to the "c:\temp\" directory on the users machine. The problem
is
that the code will work flawlessly on any other machine - ie it will save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it has
saved
the file, but when you check it is not there. I could run the code 100
times
a day and it will work 92 times without an issue and the file is saved in
the
temp directory, the other 8 times it will not be there. I can trap the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just happens.

TIA

Justin




Justin June 22nd 06 09:20 AM

Outlook save attachments problem
 
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that gets
run
in outlook. Basically the code reads the subject line and then saves the
attachment to the "c:\temp\" directory on the users machine. The problem
is
that the code will work flawlessly on any other machine - ie it will save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it has
saved
the file, but when you check it is not there. I could run the code 100
times
a day and it will work 92 times without an issue and the file is saved in
the
temp directory, the other 8 times it will not be there. I can trap the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just happens.

TIA

Justin





Dmitry Streblechenko June 22nd 06 07:02 PM

Outlook save attachments problem
 
Do check the attachment type to make suree you are only working with the
regular by-valuee attachments
Is it possible that some other app already has that file open?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that gets
run
in outlook. Basically the code reads the subject line and then saves
the
attachment to the "c:\temp\" directory on the users machine. The
problem
is
that the code will work flawlessly on any other machine - ie it will
save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it has
saved
the file, but when you check it is not there. I could run the code 100
times
a day and it will work 92 times without an issue and the file is saved
in
the
temp directory, the other 8 times it will not be there. I can trap the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just happens.

TIA

Justin







Justin June 22nd 06 11:07 PM

Outlook save attachments problem
 
At this stage in the code, only outlook is running. It is after this point
that i call word to open the file from the nominated directory.

It doesn't matter where i nominate the save location the problem seems to be
the same ie it goes through the motion of saving - but it doesn't.

The fact this worked perfectly for the past 12 months before and was still
working up until the other morning, makes me wonder if it is failing due to
an update from microsoft(i can't see how).

But this doesn't seem right either as the code works perfectly on an
identical machine not more than 6 feet away from it.

Any thoughts

Regards

Justin

"Dmitry Streblechenko" wrote:

Do check the attachment type to make suree you are only working with the
regular by-valuee attachments
Is it possible that some other app already has that file open?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that gets
run
in outlook. Basically the code reads the subject line and then saves
the
attachment to the "c:\temp\" directory on the users machine. The
problem
is
that the code will work flawlessly on any other machine - ie it will
save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it has
saved
the file, but when you check it is not there. I could run the code 100
times
a day and it will work 92 times without an issue and the file is saved
in
the
temp directory, the other 8 times it will not be there. I can trap the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just happens.

TIA

Justin







Dmitry Streblechenko June 23rd 06 12:28 AM

Outlook save attachments problem
 
Hmmm... Other than space aliens trying to play their games....
You do have the error handling on (i.e. no "on error resume next"), right?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
At this stage in the code, only outlook is running. It is after this point
that i call word to open the file from the nominated directory.

It doesn't matter where i nominate the save location the problem seems to
be
the same ie it goes through the motion of saving - but it doesn't.

The fact this worked perfectly for the past 12 months before and was still
working up until the other morning, makes me wonder if it is failing due
to
an update from microsoft(i can't see how).

But this doesn't seem right either as the code works perfectly on an
identical machine not more than 6 feet away from it.

Any thoughts

Regards

Justin

"Dmitry Streblechenko" wrote:

Do check the attachment type to make suree you are only working with the
regular by-valuee attachments
Is it possible that some other app already has that file open?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular
location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that
gets
run
in outlook. Basically the code reads the subject line and then
saves
the
attachment to the "c:\temp\" directory on the users machine. The
problem
is
that the code will work flawlessly on any other machine - ie it will
save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it
has
saved
the file, but when you check it is not there. I could run the code
100
times
a day and it will work 92 times without an issue and the file is
saved
in
the
temp directory, the other 8 times it will not be there. I can trap
the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just
happens.

TIA

Justin









Justin June 23rd 06 01:28 AM

Outlook save attachments problem
 
Unfortunately is suspect the problem is one that is not going to be easily
resolved. In this situation i can't resume on next as the next stage of the
code relies on the fact that the rtf file has been saved in the nominated
location.

I will keep looking.... Many thanks for your help.

I suspect it will be something that will right it self again as it just
stopped working.

Regards


Justin

"Dmitry Streblechenko" wrote:

Hmmm... Other than space aliens trying to play their games....
You do have the error handling on (i.e. no "on error resume next"), right?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
At this stage in the code, only outlook is running. It is after this point
that i call word to open the file from the nominated directory.

It doesn't matter where i nominate the save location the problem seems to
be
the same ie it goes through the motion of saving - but it doesn't.

The fact this worked perfectly for the past 12 months before and was still
working up until the other morning, makes me wonder if it is failing due
to
an update from microsoft(i can't see how).

But this doesn't seem right either as the code works perfectly on an
identical machine not more than 6 feet away from it.

Any thoughts

Regards

Justin

"Dmitry Streblechenko" wrote:

Do check the attachment type to make suree you are only working with the
regular by-valuee attachments
Is it possible that some other app already has that file open?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular
location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code that
gets
run
in outlook. Basically the code reads the subject line and then
saves
the
attachment to the "c:\temp\" directory on the users machine. The
problem
is
that the code will work flawlessly on any other machine - ie it will
save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says it
has
saved
the file, but when you check it is not there. I could run the code
100
times
a day and it will work 92 times without an issue and the file is
saved
in
the
temp directory, the other 8 times it will not be there. I can trap
the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just
happens.

TIA

Justin










Dmitry Streblechenko June 23rd 06 06:10 PM

Outlook save attachments problem
 
I wasn't suggesting that you use "on error resume next", but just the
opposite - making sure you don' use it so you can see all the errors raised.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Unfortunately is suspect the problem is one that is not going to be easily
resolved. In this situation i can't resume on next as the next stage of
the
code relies on the fact that the rtf file has been saved in the nominated
location.

I will keep looking.... Many thanks for your help.

I suspect it will be something that will right it self again as it just
stopped working.

Regards


Justin

"Dmitry Streblechenko" wrote:

Hmmm... Other than space aliens trying to play their games....
You do have the error handling on (i.e. no "on error resume next"),
right?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
At this stage in the code, only outlook is running. It is after this
point
that i call word to open the file from the nominated directory.

It doesn't matter where i nominate the save location the problem seems
to
be
the same ie it goes through the motion of saving - but it doesn't.

The fact this worked perfectly for the past 12 months before and was
still
working up until the other morning, makes me wonder if it is failing
due
to
an update from microsoft(i can't see how).

But this doesn't seem right either as the code works perfectly on an
identical machine not more than 6 feet away from it.

Any thoughts

Regards

Justin

"Dmitry Streblechenko" wrote:

Do check the attachment type to make suree you are only working with
the
regular by-valuee attachments
Is it possible that some other app already has that file open?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Yes,

strFilename = "c\temp\ddmmyy.rtf"

Failing that is there another way save documents to a particular
location
that won't error out ?

Regards

Justin


"Dmitry Streblechenko" wrote:

Are you sure the file name does not contain any invalid (":", etc)
characters?

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"Justin" wrote in message
...
Hi All,

I have an issue with one of my users in relation to some code
that
gets
run
in outlook. Basically the code reads the subject line and then
saves
the
attachment to the "c:\temp\" directory on the users machine. The
problem
is
that the code will work flawlessly on any other machine - ie it
will
save
an
attachment to "C:\temp\ddmmyyhhmm.rtf". For some reason it says
it
has
saved
the file, but when you check it is not there. I could run the
code
100
times
a day and it will work 92 times without an issue and the file is
saved
in
the
temp directory, the other 8 times it will not be there. I can
trap
the
error
without an issue but i don't see why it won't see the drive.

Any thoughts - or is this one of those quirky things that just
happens.

TIA

Justin













All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com