Jimi Sherman
asked on
How to save an Outlook 2010 email with an excel attachment to a folder?
When I get an email in Outlook 2010 with the subject contains the word "TEC" I need to save to a folder.
The VBA code to save an excel file to a folder will be set off by a outlook rule.
The path for the folder is...\\psf\Home\TEC Reports
Thanks,
Jimi
The VBA code to save an excel file to a folder will be set off by a outlook rule.
The path for the folder is...\\psf\Home\TEC Reports
Thanks,
Jimi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does the following path exist?
\\psf\Home\TEC Reports
\\psf\Home\TEC Reports
ASKER
Yes
Any error message you're getting?
ASKER
No error message it just stops with the debug box opens.
I got it to work when I changed the path to...."C:\Users\Jimi\Docum ents"
So if you want i can close the question and issues you the points of courses?
Jimi
I got it to work when I changed the path to...."C:\Users\Jimi\Docum
So if you want i can close the question and issues you the points of courses?
Jimi
Can you map a drive to your destination? Does it work then?
ASKER
Yes it works then.
ASKER
objAttachment.SaveAsFile sPath
Jimi