View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Checkbox not showing in Email

I have several checkboxes on a worksheet which get emailed after all filled
in, via some VB code. My problems is the checkboxes don't show in the email.
The code I'm using to send is included but I don't think it's the problem.

Worksheets("Start").Range("A1:K55").Select
ActiveWorkbook.EnvelopeVisible = True
sSubject = "PriZm Roll Log PLS: " & CStr(ActiveSheet.Range("B2").Value)
vSend = "xys@123corp"
With ActiveSheet.MailEnvelope
.Introduction = ExtraStuff
.Item.To = vSend
.Item.Subject = sSubject
.Item.Send
End With
The resulting email shows nothing (blanks)where the checkboxes are located.
Thanks Steve