ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Checkbox not showing in Email (https://www.excelbanter.com/excel-discussion-misc-queries/220430-checkbox-not-showing-email.html)

Steve

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


All times are GMT +1. The time now is 11:30 PM.

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