How to save mail Attachment in a Folder by using VBA button

How to save mail Attachment in a Folder by using VBA button 


If you want to save the active email's attachments while it is open, you can use the following VBA code:

Please replace "C:\Your\Defined\Folder\Path\" with the path where you want to save the attachments. You can run this code from the Developer tab in Outlook after you've created a new module in the VBA editor and pasted the code into it. This code is designed to work on the currently active email and save its attachments to the specified folder.

  • Select any incoming mail
  • Click on Developer Tab


  • Click on Visual Basic tab.



  • Create a New Folder.
  • Copy folder path



  • After Paste VBA Code replace folder path 
  • Click on close and return to microsoft outlook.

  • Click on File tab
  • Click on Customize Ribbon tab
  • Select Macro
  • Select Main Tab
  • Select Massage tab
  • Click on New Group
  • Do rename of New Group 
  • Select New Group again
  • Select VBA Code (Ex. Project 1 Module 2....) 
  • Click on add button.
  • Select added VBA Code under New Group.
  • Click on New Tab
  • Do rename of New Tab
  • Select any Icon and click on "ok"


  • Click any incoming mail.
  • You will see new icon under massage tab
  • Click on button.
  • See the attachment in Folder 

  • Attachment will be saved in folder.




Thank you

Comments

Popular posts from this blog

Skill Matrix Tool & Excel Format

How to take print out of multiple pdf files in one click.

Use Vlookup in multiple columns at a time