The add-in will bring this text to your template as is. If you’re happy with plain text that has no formatting at all, simply type the required extracts one by one in an individual cell each (on the right of the corresponding email address, of course). Get links to other images in the same way and paste them in the corresponding rows:.Make sure that the email address of your teammate who the image is intended for is in the same row: Paste the copied line into your Excel table.Select and copy the ~%InsertPictureFromOneDrive macro along with the link created:.Find the View HTML and View Template Content icons on the editor toolbar.Fill in the boxes of the Insert picture dialog window (the way you need) and click Insert.Otherwise, your colleagues won’t have access to them. Don’t forget to share these files beforehand. Select a file that contains one of the images you would like to swap.Find and pick this one: ~%InsertPictureFromOneDrive. You’ll see a list of all the macros the add-in has.Click the New Template button, and then click the Insert Macro icon.
CREATE OUTLOOK EMAIL FROM TEMPLATE HOW TO
Images to insert: How to get a link that will work The email addresses in my screenshots are imaginary-just to give you an example 🙂Ĭolumn B (‘Image’), column C (‘Text’), and column D (‘Attachment’) are still empty and have to be filled. The email addresses, which your teammates’ Shared Email Templates accounts are registered to, are in column A. Generate proper content for the tableĪt this stage, your table may be like this one: Be sure to create these links with the Shared Email Templates add-in as described below, otherwise they won’t work the right way. I mean pieces of text and links to files that your teammates are interested in. All the other columns are reserved for the items that will be dynamically inserted into an email.Using them, the add-in will be able to find the right image, attachment, and text for each person. They will be sort of reference points for Shared Email Templates. The leftmost column of the table should contain your colleagues’ email addresses.How would you do that? Check both the structure and the content of your table: Prepare your Excel tableįirst, make sure you have all the necessary variables in one and the same Excel table stored, say, in OneDrive. So, when the template is going to be pasted into the email body by another person, all this stuff should change automatically.ĭo you think that such a task is too difficult? Nothing of the kind … for our smart Shared Email Templates add-in 🙂 Just a few steps to take, and a dynamic Outlook template for your team will be ready. The problem is that each of your colleagues would like to get a different image, an individual attachment, and some specific text added to the template every time they use it. Let’s say, you have a really nice template, and your teammates would be happy to use it in their correspondence, but you’re stuck on making this template dynamic. On reading this blog post, you’ll learn how to automatically switch images, attachments, and text in a shared Outlook template, depending on the current user.
0 kommentar(er)
