Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Worksheets("Start").Range("A1:K55").Select
ActiveWorkbook.EnvelopeVisible = True sSubject = "Any Text " & CStr(ActiveSheet.Range("B2").Value) ' vSend = "zxc@123corp" With ActiveSheet.MailEnvelope .Introduction = ExtraStuff .Item.To = vSend .Item.Subject = sSubject .Item.Send End With This above code runs and the resulting email shows blank where the checkboxes should be |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide/Show some worksheets | Excel Discussion (Misc queries) | |||
Checkbox checked then show more checkboxes | New Users to Excel | |||
Using checkboxes to print multiple worksheets | Excel Discussion (Misc queries) | |||
Help, losing protection & read only with worksheets emailed out | Excel Discussion (Misc queries) | |||
Emailed worksheets read only | Excel Discussion (Misc queries) |