LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default Checkboxes do not show when Worksheets Emailed

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide/Show some worksheets Tony S.[_2_] Excel Discussion (Misc queries) 8 January 18th 09 07:28 PM
Checkbox checked then show more checkboxes Sara New Users to Excel 3 September 10th 08 07:16 PM
Using checkboxes to print multiple worksheets KathyN Excel Discussion (Misc queries) 3 March 19th 08 04:28 PM
Help, losing protection & read only with worksheets emailed out greg Excel Discussion (Misc queries) 0 February 15th 07 07:15 PM
Emailed worksheets read only Toddt Excel Discussion (Misc queries) 0 February 6th 07 08:27 PM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"