This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? To avoid errors, replace 'Dan Wilson' with a valid name in your address book. Have questions or feedback about Office VBA or this documentation?
Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. Then excel will do everything, but it ignore all formatting in the text body and I cant get it to select multiple cells for the text body. I don't even know where to begin with this one. Below is the basic VBA for sending an email on outlook. But of course, the range for the email body doesnt work.
To Preserves original formatting once you copy the range, work with Word object model with MailItem. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Sending an auto-filled Outlook email template from Excel with multiple cell text body and additional text formatting Ask Question.
Asked 3 years, 10 months ago. Active 11 months ago. Viewed 19k times. Your fillable email template for Outlook is good to go. Preparing an email template for sending out is as easy as it could possibly be. To insert a template into a message, double-click on it or click the Paste icon on the left.
A small form will show up asking you to pick a date from a dropdown calendar and enter a percentage discount in the text box:. The steps to add a dropdown list to your email template are the same as described above.
The only difference is step 4 where you configure the What To Enter fields:. To be able to enter a value other than in the dropdown list, select the User can edit selected items checkbox.
To limit the input to the predefined items, leave this box unselected. If any changes are needed at a later point, you can edit the dropdown items directly in the template without recreating the macro from scratch. In a similar fashion, we insert one more macro for the percentage discount. In this case, we limit the choices to only the items in the drop-down list the User can edit selected items checkbox is unselected :. After all these customizations, our Outlook email template with two dropdown lists looks as follows:.
When inserting the template in a message, the following form will appear asking you to select both values:. It was a quick demonstration of just one capability of Shared Email Templates.
0コメント