LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
ljr ljr is offline
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do page breaks change in excel when spreadhseet sent as email cptgold Excel Discussion (Misc queries) 2 February 23rd 09 06:22 PM
How to change the color of a page Charlie Excel Programming 3 December 23rd 07 03:03 PM
Page Number Color In Page Break Preview D. Schultz Excel Discussion (Misc queries) 0 October 25th 06 12:52 AM
change font color whenever click a page of multipage control tom taol Excel Programming 0 October 12th 05 10:45 PM
Browse Forms Controls and change TextBox color based on cell color StefanW Excel Programming 2 November 21st 04 07:06 PM


All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"