Hi, Thanks for your prompt response.
I am using Office 2007. My requirement is to first create a rule that will sort the mails depending on the deadlines. Secondly create a list of mails received. Thanks & Regards, Yogesh Kudva On Sun, Nov 28, 2010 at 11:59 AM, <in.vaib...@gmail.com> wrote: > Dear Yogesh, > > Pl state your requirement in terms if action to be performed on receipt of > email. > > Also mention which version of Excel you are using. > > Sent on my BlackBerry® from Vodafone > > -----Original Message----- > From: Yogesh Kudva <yogeshku...@gmail.com> > Sender: excel-macros@googlegroups.com > Date: Sat, 27 Nov 2010 21:14:31 > To: MS EXCEL AND VBA MACROS<excel-macros@googlegroups.com> > Reply-To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Integrating Outlook with Excel > > Hello Group, > > My office email account is configured in Outlook 2007. Along with that > I also have a Mailbox configured with my Primary account. We get mails > from our clients on which we need to action and there are different > deadlines (Deadline 1 to 4). The subject of the mails which we receive > are not uniform. Some mention the Account #, some mention the Name, > whereas some of them mention a different #. Secondly there are some > mails which we receive for deadline 2 or 3 early in the morning > itself. > > I tried to create rules but they don’t seem to work on the mailbox. I > found a macro which creates a list of mails received in Excel but > that too works only for the mails of the Primary Inbox and not of the > Mailbox Inbox. > > Could anyone of you help me with the same? > > Thanking you in anticipation. > > Yours truly, > > Yogesh Kudva > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts