VBA code to remove attachments

[stevewood1]

Hello,

Can anyone help me with some VBA code that will remove attachments from a generated email? When I've looked online I've found examples that run in Outlook through an inbox but I have a Macro on an excel form that automatically generates an email and because I've used .HTML body to specify a font size, where individual users have pictures on their signature block it's adding them on as an attachment.

I need some code that will remove these attachments but will still allow me to email the excel workbook as an attachment which was the reason for the form.

Many thanks,

Steve

 

[stevewood1]

Panic over. It turns out I just can't spell 'Variant'. I've corrected that and it now seems to be working fine.

Thanks for al you help.