Noob to Outlook and VBA
 

Hi All

Apologies if this is in the wrong place to start off with,

I am currently looking for some assistance in been able to obtain some VBA code that I can run from a rule within in Outlook. I work within in a busy office and I receive many emails that have attachments which I would like to save to a folder on our network or Desktop folder depending on the type of file that has been attached (tiff, pdf, jpeg and exel)

The Vba Code needs to do the following:

1. Check the incoming email for attachments (which is based on a rule)

2. Check the attachment file extension (excel, csv, pdf, tiff)

3 If the file extension meets the following criteria:


if attachment.extension = excel
then save it to C:\Documents And Settings\" & _
UserN & "\Desktop\Shared\excel"


if attachment.extension = CSV
then save it to C:\Documents And Settings\" & _
UserN & "\Desktop\Shared\CSVFiles"


if attachment.extension = jpeg
then save it to C:\Documents And Settings\" & _
UserN & "\Desktop\Shared\JpegFiles"

if attachment.extension = .tiff
then save it to C:\Documents And Settings\" & _
UserN & "\Desktop\Shared\.tifffiles"

(if the attachments could be saved with the name and date stamp for each)

Then the lastly move the email to the Archive folder called PODS


If someone could assist me in this I would be most grateful for this, as my skills at writing code is non existent (only just discovered VBA after watching someone use it to send automatic emails) and I am trying learn as I go along