|All Industries, Financial Model, General Excel Financial Models|
|Excel, Financial Model, Financial Modeling, Macros|
Connecting Excel to Outlook programmatically will be useful if you:
1. Prepare regular reports and send them out by e-mail.
2. Receive information by e-mail which you then download and process for further analysis and reporting.
This post contains examples of working with Outlook through Excel. After studying these examples you will be able to automate the above processes or integrate them into your existing VBA routines.
1. Short version includes:
– A file sending emails from Excel. You can choose recipients, define subject and body text, insert file attachments, request a read receipt, preview an e-mail, or to send it immediately as you push the button.
– An extended file (demo version) demonstrating how to include rich-text tables, embedded pictures, access Outlook folders, browse through emails and retrieve their senders, recipient, subject, message body, and attachments, reply, forward, and delete emails.
File Types: Short Excel Model = 1 file of .xlsm , Free Demonstration = .xlsm
2. Full version includes:
– An unlocked version of the above file with full functionality (broken down into two files for users’ convenience).
– The files contain VBA macros, so make sure you have macros enabled when opening the files.
File Types: Full Excel Model = 2 files of .xlsm , Commentary/Macro Documentation = .docx