Phil Smith
08-28-2010, 12:00 PM
I receive quite a lot of email from my union, most of which is about other (rail) companies other than the one I work for.
Each attachment filename contains the name of the company concerned and I was wondering if it is possible to use VBA to check the attachment filenames and then filter the email accordingly?
For example, if the email has an attachment whose filename contains "CompanyName" then move the email to "My Union Email" folder, otherwise move it to "Other Union Email". Alternatively save just the attachment to a folder such as "Union Correspondence" in Documents?
Thanks in advance!
Phil
Each attachment filename contains the name of the company concerned and I was wondering if it is possible to use VBA to check the attachment filenames and then filter the email accordingly?
For example, if the email has an attachment whose filename contains "CompanyName" then move the email to "My Union Email" folder, otherwise move it to "Other Union Email". Alternatively save just the attachment to a folder such as "Union Correspondence" in Documents?
Thanks in advance!
Phil