VBA Excel Attachment Email - Triggers Anti Virus Softtware and Deletes

Hi All,

This is a weird situtaion. If I send an attachment from an unsaved workbook or active workbook to an Outlook email, my Company's anit-virus software immediately tags it as a virus. Even if I comment the attachment code line anit-virus will delete all macros from that workbook immediately.

I feel sending the email thorugh Access might not trigger the anti-virus because emails are sent from an Access database with other codes and it works fine.

My question is how can I use Access temporarily to just send the email. I also have ranges from the Excel spreadsheet I am using to send though the RangetoHtml custom function. Is this possible? Or is there another way around this anti-virus issue?