View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rich[_29_] Rich[_29_] is offline
external usenet poster
 
Posts: 2
Default CDO.Message seems to remove formatting from Excel file

Answered my own question. For those with a similar issue, it seems you
need to specify a few additional things:

objNewMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objNewMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = _
"myserverl"
objNewMail.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objNewMail.Configuration.Fields.Update

Details can be found at:
http://www.microsoft.com/technet/scr..._ent_wbpa.mspx