How to get remove mail from shared excel 2016 mail

The pesky shared Excel 2016 mail!

To remove mail from a shared Excel 2016 file, you can try the following methods:

Method 1: Delete the mail from the "Mailings" tab

1. Open your shared Excel 2016 file.
2. Go to the "Mailings" tab in the ribbon.
3. Click on the "Mailings" group and select "Delete Mailing" from the dropdown menu.
4. Select the mail you want to delete and click "OK".

Method 2: Use the "Remove All Mailing" option

1. Open your shared Excel 2016 file.
2. Go to the "Mailings" tab in the ribbon.
3. Click on the "Mailings" group and select "Remove All Mailing" from the dropdown menu.
4. Confirm that you want to remove all mailings by clicking "OK".

Method 3: Use VBA code

1. Open your shared Excel 2016 file.
2. Press "Alt + F11" to open the Visual Basic Editor.
3. In the Editor, navigate to the "Mailings" module (e.g., "Mailings.xla").
4. Look for the "RemoveMailing" procedure and click on it to open its code.
5. Add the following code to the procedure:

   Sub RemoveMailing()
    Dim objMail As Object
    For Each objMail In ThisWorkbook.Mailings
        objMail.Delete
    Next objMail
   End Sub

6. Save the changes and close the Editor.
7. Go back to your Excel file and click on the "Mailings" tab.
8. Click on the "Mailings" group and select "Run" from the dropdown menu.
9. Select the "RemoveMailing" procedure and click "OK".

Method 4: Use a third-party add-in

If you're using a third-party add-in like "Mail Merge Toolkit" or "Excel Mail Merge", you may be able to use its built-in functionality to remove mail from your shared Excel 2016 file.

Remember to always save your changes before closing the file to ensure that the mail is removed successfully.