View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default CheckBox doesn't show in Email

ActiveWorkbook.EnvelopeVisible = True
sSubject = "Any Text " & CStr(ActiveSheet.Range("B2").Value)
vSend = "
With ActiveSheet.MailEnvelope
.Introduction = ExtraStuff
.Item.To = vSend
.Item.Subject = sSubject
.Item.Send
End With

When I send a spreadsheet with the above code, the multiple checboxes in the
captured area do not show in the Email (Outlook). Is there a setting or code
that would make these visible as they reflect choices made during data entry.
Thanks Steve