Avatar of Justin

asked on 

Macro which automatically send Excel spreadsheet to Outlook problem

Hi Guys, on the attachment, I have a macro which copies and pastes Values the sheet "ECB calc" to an attachment in Outlook and sends it .

However, when the recipient opens the attachment, there is a message saying "This workbook contains links to one or more external sources".

How do I get rid of this warning message? Also, I don't want to copy and paste the actual macro so the recipient does not see it. How do I do this?
OutlookMicrosoft ExcelSpreadsheetsVisual Basic Classic

Avatar of undefined
Last Comment

8/22/2022 - Mon