![]() |
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