Strange Outlook VBA Error

[jdrawmer]

Hi all,

I'm attempting to create a button macro that stores emails in a specific 'job' folder. You select the job in a drop down list, the macro integrates with an email register in excel, saves it in there then saves the email...

Everything is working perfectly, except for the saving of the email itself, i keep getting the error:

Run-time error '-2147287038 (80030003)':
The operation failed.

The error isn't specific when de-bugged, and my code the the saving of the email is...

xItem.SaveAs ("C:\Documents and Settings\jdrawmer\Desktop\Putithere\5580\INPUT\" & txtJobNumber.Text & " " & txtEmailSubject.Text & ".msg")

I know xItem is working fine, as are the txtJobNumber and txtEmailSubject text boxes, as other properties of them, are being used in the code before it without problem. I just wanna know why, if its obvious or possible, that its not saving - and/ or a solution!

Thanks,
Jay

 

[PHV]

What are the values of txtJobNumber and txtEmailSubject ?
No illegal character for pathname ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jdrawmer]

in the scenario i am currently texting, txtJobNumber is

N5575-008

and txtEmal Subject is

Missing Standard

I didn't think they contained illegal chars, but maybe.

Thanks

 

[PHV]

I don't see illegal chars too.
Have you sufficient rights (permissions) on the C:\Documents and Settings\jdrawmer\Desktop\Putithere\5580\INPUT folder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jdrawmer]

yeah definately. If i wanted to save the email manually thats not a problem, it just refuses to do it really!

Such random programming

Thanks