Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-10 Thread Rohan Young
Dears, i m facing run time error 1004 For Each oitem In myItems Sheets("Inbox Scan").Cells(i, 1).Value = oitem.SenderName Sheets("Inbox Scan").Cells(i, 2).Value = oitem.SenderEmailAddress 'Sheets("Inbox Scan").Cells(i, 3).Value = oitem.Subject 'Sheets("Inbox Sc

Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-07 Thread Anand Kumar
Dear Rohan, The code seems to be correct. You need to add some libraries it seems. Regards, Anand On Friday, 6 July 2012 10:11:16 UTC+5:30, Rohan Young wrote: > > Dear Ashish Ji, > > thanks but i m not getting the result, can you please send me the add > in or anything else for it > > regds

Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread Rohan Young
Dear Ashish Ji, thanks but i m not getting the result, can you please send me the add in or anything else for it regds ROHAN On Thu, Jul 5, 2012 at 10:58 PM, ashish koul wrote: > try this see if it helps > > Sub Scan_my_outlook_inbox() > 'TOOLS ->Refrence -> microsoft outlook > 'declare outloo

Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread ashish koul
try this see if it helps Sub Scan_my_outlook_inbox() 'TOOLS ->Refrence -> microsoft outlook 'declare outlook objects Dim olapp As Outlook.Application Dim olappns As Outlook.Namespace Dim oinbox As Outlook.Folder Dim oitem As Outlook.MailItem Dim myItems As Outlook.Items Dim i As Long i = 2 'set ou

Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread Rohan Young
Dear Sanjib, Its not working & improting i need to import all Mail IDs from My Sent & Inbox Folder, i need any macro for this thanks On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee wrote: > Just follow follow the link > > http://support.microsoft.com/kb/295664 > > > On Thu, Jul 5, 2012 at 3:

Re: $$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread Sanjib Chatterjee
Just follow follow the link http://support.microsoft.com/kb/295664 On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young wrote: > Dear Group, > > how can i get all mail IDs from my outlook to excel to make a list of > all IDs and Co., please help me out > > Thanks & Regds > > ROHAN > > -- > FORUM RULES

$$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread Rohan Young
Dear Group, how can i get all mail IDs from my outlook to excel to make a list of all IDs and Co., please help me out Thanks & Regds ROHAN -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need He