ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Include Checkboxes or Controls in email (https://www.excelbanter.com/excel-discussion-misc-queries/147216-include-checkboxes-controls-email.html)

Steve

Include Checkboxes or Controls in email
 
I have several Checkboxes in the selected range but they do not show up in
the received email. Is there a setting in the Checkbox properties that I need
to set or a better way to email the range? The code below is just an example
of what is actually used.

' Select the range of cells on the active worksheet.
ActiveSheet.Range("A1:B20").Select

' Show the envelope on the ActiveWorkbook.
ActiveWorkbook.EnvelopeVisible = True

' Set the optional introduction field thats adds
' some header text to the email body. It also sets
' the To and Subject lines. Finally the message
' is sent.
With ActiveSheet.MailEnvelope
.Introduction = "This is a sample worksheet."
.Item.To = "E-Mail_Address_Here"
.Item.Subject = "My subject"
.Item.Send
End With


All times are GMT +1. The time now is 06:05 PM.

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