PDA

View Full Version : Macro to create an outlook appointment using specific cells in my spreadsheet & email



Katiapro93
10-15-2015, 07:59 AM
I am new to VBA Express, but I used it once and it saved me a bunch of time. I need to do a macro that opens my outlook and creates an appointment using information from specific cells in my spreadsheet. Then I want it to create an e-mail (using outlook) again with specific information from certain cells. Finally, I want to show a button that people can press and it will do these functions. Can I do this?

Example:

Form
Closing Date: 10-15-15 Funding: 10-19-15
Closer: Smith Ref: Smith - loan #123123

Macro opens Outlook appointment and uses the cell showing the funding date and uses the cell showing Ref: for body, etc. Same goes for e-mail.