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

Checkboxes do not show when Worksheets Emailed
 

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

Checkboxes do not show when Worksheets Emailed
 

Thanks Ron
I will try the code. Got an error message on the 1st attempt to post this
question so tried again. Sorry for the double post and thanks for your help

"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

Checkboxes do not show when Worksheets Emailed
 

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

Checkboxes do not show when Worksheets Emailed
 

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