Hi Guys,
My objective is to update an excel sheet, whenever I am getting mails with a particular subject (I set up a rule for moving relevant mails to a folder).
Outlook Folder :
Inbox > "Banker Mail"
Mail contains which i need to Paste in Excel sheet:
Mail Subject & Mail Recipient(To & Cc)(each in Individual Columns)
I will get this mail daily and need to update this info in an excel sheet. (which i will keep open till the month end)
Please help me. Thanks in advance
Regards
Ritesh
It is easy enough to set up a 'Watcher' in Excel which will fire when a new item arrives in an Outlook folder. Do you have any existing code to access the mailbox?
It can also be done in Outlook using VBA but Excel is the easier option.
Last edited by cytop; 06-17-2016 at 03:47 AM.
thanks for your kind revert on my problem,
No,i dont have any earlier coding for this.as i am new with VBA macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks