200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi.
i've saved several email templates to my desktop, and different types of content/body for the emails in an excel sheet.
example: template 1 - dear customer, template 2 - deal supplier
content/body in excel - A1. thank you for your order, A2. required order
i would like to create a macro that first allows me to select the appropriate template, then be able to select the appropriate content, then have a button to launch the finished email.
how can i create this?
thank you in advance.
Outlook provides the feature you are trying to program. Click on New Mail, write whatever you want as a template and select it. Now select the ribbon's Insert tab and click Quick Parts in the Text menu. Clicking Save Selection to Quick Part Gallery will open a dialog box where you can give your selection and name and decide where to store it.
When you want to use a stored text, click on New Mail, place the cursor in the body panel, click on Quick Parts and select the item you want to use. You can use different paragraphs to assemble customised messages and edit the texts even after they have been inserted. Set up a signature to sign your mails.
I use this system all the time. It is much faster than what you describe to want to do with the help of Excel and VBA. With half a dozen clicks a mail is prepared, signed and sent.
