Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
Outlook email showing up in Excel - Would like to remove | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) | |||
Email hyperlink changes not showing in excel | Excel Worksheet Functions | |||
background color showing only when in email form | Excel Discussion (Misc queries) |