ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CheckBox doesn't show in Email (https://www.excelbanter.com/excel-discussion-misc-queries/220561-checkbox-doesnt-show-email.html)

Steve

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

Ron de Bruin

CheckBox doesn't show in Email
 
I reply in your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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



All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com