0

I send these kind of mails to intimate people about upcoming meeting, the format I prepare in Excel 2013 and paste it in Outlook 2013 (as a table, not as an image)

Now one of the columns I put as 'Days Remaining' which basically tells the users how many days are there to the review, the image below will show how it looks:

enter image description here

Now the numbers of days remaining will be correct the day I send the mail, but when somebody opens the mail at a later date, it would not sort of show the true number.

Is there a way to auto-update this number inside the Outlook mail, as it works in an Excel Sheet?

A non-vba approach would be welcome, because with macros, its difficult to implement in other systems.

0

There has been a similar topic covered on stackoverflow. You can find it here

Not sure if it will be of much use to you, but should point you in the right direction.

0

The answer posted by Matthew might work but probably will not for most people using work systems as they are likely to have VBA turned off in Outlook for security reasons.

They would need to allow VBA to be turned on - probably to only trust signed macros. You would then need to sign the macro and distribute it to them. Quite a lot of bother to go through simply to get the text to update.

Alternatives would be to try embedding JavaScript - though this is also unlikely to work for most peopole. Embedding a web page as an iFrame (also likely to be blocked by security settings). Or, perhaps the best option, sending them a set meeting invites instead.

One other springs to mind, though I'm not certain it would work, would be to send the information as an embedded InfoPath form. Not sure to be honest how dynamic that is when embedded.

  • I was hoping for a non-VBA solution, especially when it involves a lot of people... Was hoping for a simple solution, but this sounds complex, maybe not worth the effort. Thanks anyways. – Firee Feb 10 '14 at 12:50
  • I agree - almost certainly not worth it I'm afraid. – Julian Knight Feb 10 '14 at 17:29
0

In order to achieve the desired result, insert Excel table as object, not by copy-pasting. Follow the Insert -> Object on Outlook message form and select Microsoft Excel Worksheet

  • Does not work, outlook converts the worksheet as an image while sending. – Firee Feb 10 '14 at 12:48
  • I tried converting it to Rich Text format, which does not convert it to an image, but it does not auto-update it. – Firee Feb 10 '14 at 13:18

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.