Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Outlook 2003 - Macro Help

Oct 11, 2010 5:19AM PDT

On a monthly basis I must copy the e-mails in forty files and paste them in to a file on my hard drive. Basically, Go to the file > select all > edit > copy then paste into a file on my hard drive. I will like to automate this task with a macro instead of doing each file separately. Any help would be appreciated.

Discussion is locked

- Collapse -
Re: Outlook 2003 macro
Oct 11, 2010 7:45AM PDT
http://www.outlookcode.com/article.aspx?ID=40 might be a good start. However, your use of "file" (where you probably mean "Outlook folder" and "Windows folder" respectively) makes me suspect you're not a programmer, so you will have a steep learning curve. Moreover, I doubt if pasting into a non-Outlook environment (the "file" on your hard drive) can be done with a macro from Outlook. So it might be impossible this way. Then see if Export works.


Kees
- Collapse -
Re: Outlook 2003 macro - New!
Oct 11, 2010 8:41AM PDT

Kees,

Correct, I am not a programmer, I am a slave to "Record a Macro" in Excel.
Yes folders are correct, not files. Pasting from Outlook folder into a hard drive folder is possible as I do it all the time. I will check out your suggestion and get back to you.

Thanks