Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
How do i include the original workbook in the email message creat. | Excel Discussion (Misc queries) | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions |