Outlook Template linked to Spreadsheet?

[Tony]

Is it possible to create a Template in Outlook that when opened, it displays
the contents of a worksheet from an Excel file; such that if the Excel file
gets updated, the next time the Outlook template is opened, it will reflect
the updated worksheet? In other words, a template that fetches the current
contents of the worksheet, each time it's used? If so, can you explain, or
point me to a place where it's explained, how to do it?

Thanks in advance,
Tony

 

[Tony]

Test reply auto-notify - TD

 

[Frank Pytel]

tony;

This is a VBA thing. You can write VBA for Outlook, create a macro. You
would have to create two. One to check the file and one to open the file if
something has changed. I would suggest referencing the macro to the last time
the spreadsheet was viewed/modified. Unfortunately, this will include someone
opening and then closing the file without modifications.

Post in Outlook VBA.

God Bless

Frank Pytel