Hi Steve
I have test it in 2007
Do you use another version
Let me know and I will test it also in that version
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Steve" wrote in message ...
Ron
I'm still not seeing the checkboxes. I have tried both with and without
pictures. I am not using a form just directly inputting to a worksheet which
has Checkboxes located on it.
Thanks again for your help
Steve
"Ron de Bruin" wrote:
Hi Steve
I see both (forms and activex checkboxes if I mail)
http://www.rondebruin.nl/mail/folder3/mailenvelope.htm
Note: in 2007
If you use Conditional Formatting Icons or Data bars in your Excel 2007 workbook the
receiver will not see them in the mail.
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Steve" wrote in message ...
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