Hi there,
I'm using RangetoHTML to send chunks of a spreadsheet via CDO emails to lots of recipients. The range is fairly small, and contains basic text, however the "RangetoHTML" function (which I am not really keen on since I cut & paste it but have not yet figured out exactly how it works) makes each of my messages 2MB in size, which is pretty poor given the small amount of actual data.
Is there anything I can do to improve the function's efficiency by removing the junk HTML code?
Thanks!
I'm using RangetoHTML to send chunks of a spreadsheet via CDO emails to lots of recipients. The range is fairly small, and contains basic text, however the "RangetoHTML" function (which I am not really keen on since I cut & paste it but have not yet figured out exactly how it works) makes each of my messages 2MB in size, which is pretty poor given the small amount of actual data.
Is there anything I can do to improve the function's efficiency by removing the junk HTML code?
Thanks!