ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change email page color (https://www.excelbanter.com/excel-programming/405610-change-email-page-color.html)

ljr

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