Copy Email messages to Excel..Macro will not work....Outlook 7 and Excel 7

  • I am using Ron de Bruin's macro but can't get it to work. Can someone help? Thanks, Here is the Code I copied from his posting.

  • Re: Copy Email messages to Excel..Macro will not work....Outlook 7 and Excel 7


    Some indication of why it's not working, or where it falls down, would be useful for anyone reading this who cannot run Excel or Outlook...

  • Re: Copy Email messages to Excel..Macro will not work....Outlook 7 and Excel 7


    It has no error messages because error trapping is turned off. Comment out the line

    Code
    On Error Resume Next

    and then see what happens...

  • Re: Copy Email messages to Excel..Macro will not work....Outlook 7 and Excel 7


    It says error code 424....no object...I commented out the next statement and it says the samething.

  • Re: Copy Email messages to Excel..Macro will not work....Outlook 7 and Excel 7


    OK - but my previous comment

    Quote

    ...where it falls down

    still applies.


    You're looking for help on this - you should give full details of the problem...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!