![]() |
change email page color
I have been asked to put code in an excel spreadsheet to be used for a
template on secure spreadsheets. There have been personal files opened from someone within the company during the evening hours (from home). Files are stored on fileserver and folders secured based on user, so it can only be users who have the authority to the folder. Think that should give a good ideal who is opening the documents. I have created modules in vbe to log user and timestamp upon opening the spreadsheet. I also have another module to automatically send an email with filename, user, timestamp. Email is sent without the user knowing it by using our email fileserver and microsoft schema. My problem is, it was requested to change the page color of the email to pink (as in a warning). I have the following code but I'm not able to figure what keyword and code to use. I not at all familiar with vb code in excel. Any help would be appreciated - Thanks! With iMsg Set .Configuration = iConf .To = " .CC = " .BCC = " .From = " " .Subject = "WARNING!!! WARNING!!! WARNING!!!" .fields.Update .TextBody = strbody ???? .Background = vbMagenta .send End With |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com