auto send messages

P

pm

I'm new to outlook vba and tring to find if theres a way to send an email
automatically if its vbFriday, if it is then lookup for a value in a excel
file that is either located on same machine or attached to a mail message in
the mail box itself itself and send the value as mail text.
Is this possible ?
 
K

Ken Slovak - [MVP - Outlook]

You would have to save any attachments to the file system before you are
able to work with them.

See http://www.outlookcode.com/d/customimport.htm for some examples of
working with Excel using code from Outlook. You can adapt those samples for
your Excel part. There is lots of other Outlook programming information at
www.outlookcode.com for the other parts of what you want to do.
 
Top