Sending emails with objects

**ya7omar** · 02-08-2010, 10:28 AM

Hi all,

I have a macro that will send all the data on a sheet be part of the email in outlook (it doesn't attach the sheet). The only issue is that i have a few checkboxes and one image and when i copy the sheet it doesn't copy any of them.Here is the code that i'm using

Please Login or Register  to view this content.

Is there anything i can do to include the checkboxes in the mail.

Thanks

**blane245** · 02-08-2010, 12:03 PM

I did a little playing around with "Save As Web Page..." on the File Menu and noticed that it won't show a checkbox or a command button, until I added a clip art image. You might try .SaveAs rather than .PublishObjects. Record a macro when you select Save as Web Page... and see what it does.

**blane245** · 02-08-2010, 01:01 PM

Once thing I've noticed using the SaveAs method is that Excel creates a folder with the same name as the htm file to hold all of the images. You will have to include these file in the email as well as they are referenced by the html.

**ya7omar** · 02-09-2010, 04:09 AM

Thanks for the response. If i understood the saveAs function correctly, it will send an excel file and not a HTML. I want to upload this on the main server for everyone to use, so i'd rather not include any code that will create folders and save files on their laptops.
So my question basically is, is there a way to send the sheet in HTML and include checkboxes.

Thanks

**blane245** · 02-09-2010, 08:39 AM

I am speaking of the Save as Web Page... option, not Save As. When you save a file as a web page it creates a folder to put all of the graphics in. The checkboxes are saved as graphical images in a separate associated folder.

**ya7omar** · 02-09-2010, 09:51 AM

Can you give me an example of how to change my code to include Save as web page. I tried looking it up but couldn't find it anywhere.

**blane245** · 02-09-2010, 10:31 AM

Here is a zip file containing an Excel file that has a small amount of data, a couple of checkboxes, and a macro recorded in Module1 where I used the Save as Web Page... entry from the File menu. Also, it contains the saved htm file and the folder containing the necessary files to show the checkboxes. You must use IE to display the ActiveX controls for the check boxes.
ya7omar_files.zip