• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • Last Modified:

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?
1 Solution
Ejgil HedegaardCommented:
Check attached, where all (visible) names are deleted, links broken (no need to copy, paste values then), and button deleted.
JCutcliffeAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now