beverly1990

Hi - I spend about two hours a day doing something that I'm pretty sure can be automated.

I'm totally unfamiliar with macros (beyond simply recording and replaying) and I'm wondering if the following is possible:

I need to open a word document with an unknown amount of raw data that is emailed to me daily and run a macro that will:

1. Find each page that meets a certain condition (i.e., has "YES" on a certain line).
3. CUT each page out of the original document that meets the condition.
4. Paste each into its own -new- document.
5. Insert a small table into each one page document. This table is located in an entirely separate word document all by itself.
6. Format the table so that it is centered at the bottom of each one page document.
7. Go to a specific location of each document and select/copy a string of text (i.e., a User ID on line 7).
8. Get the "last,first" name from my outlook address book that is associated with this User ID.
9. Paste the "last,first" name into the table on the bottom of the corresponding word document.
10. Save each document as the name that is pasted in its table and taken from its User ID.
11. Save the original document (the one with all of the raw data) as today's date after all of the conditional one page sections have been removed.


Would be nice, huh? Can anyone help?