View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Checkboxes do not show when Worksheets Emailed

Worksheets("Start").Range("A1:K55").Select
ActiveWorkbook.EnvelopeVisible = True
sSubject = "Any Text " & CStr(ActiveSheet.Range("B2").Value)
' vSend = "zxc@123corp"
With ActiveSheet.MailEnvelope
.Introduction = ExtraStuff
.Item.To = vSend
.Item.Subject = sSubject
.Item.Send
End With

This above code runs and the resulting email shows blank where the
checkboxes should be