Thread: Macro for fastest way to paste an email recipient to 400 word docs in the same folder

Hello all...

Is there some macro that can do this....

1. Open first Word Document in a certain folder.
2. Position/put the cursor in the BCC field (the email area would be open).
3. Paste an email recipient's name in the BCC Field
4. Save and Close the Word Document
5. Open the next Word Document in the folder.
6. Repeat steps 2 to 4.

I need to do this for 400 Words Docs! Ouch!

Any thoughts/help on this would be much appreciated

Thanks much!

Thanks for the info Bird but I've been blocked out of that link (company has blocked it).

Is there a way that you can just paste the code here rather than the link?

Thanks much

Hi VBA,

I got a "wasn't correctly coded" message and could not be opened. I just upgraded to Adobe Reader 9.0. Would you try and open it and let me know if you also have a problem?

Maybe you can try uploading it again?

Thanks much,

duugg

Okay, here's the latest scoop.

I need this macro to be able to STOP in the BCC field name so that I can then paste the email name into. None of this code tells me how to do that. I did try macro recording to get the insertion point into the BCC field but have had no luck because the STOP button in the macro recorder is grayed out when in the email field.

I already tried this

1. Started the macro
2. Pressed ALT+J to go to the subject field
3. Pressed ALT+Tab to go to the BCC field
4. While in the BCC Field, I Typed in "BCC Text test"
5. Went to press the Stop button in the macro recorder, it is greyed out.
6. Because the Stop button was greyed out, I tried pressed tab 3 times
to go back into "Word" area of the document.
7. While in the "Word" area of the document, I typed "Body Text Test"
8. The Stop button was no longer greyed out, so I stopped
the macro recording by pressing the Stop button
9. And here's the resulting code:

Code:

Sub BCC03()

' BCC03 Macro

    WordBasic.EmailFocusSubject
    Selection.TypeText Text:="Body text test"
End Sub

Notice that the following 2 things didn't even show up in the macro...

1. Shift+TAB to go to the BCC Field (even though I tabbed to this field)
2. The text "BCC Text Test" didn't show up at all (even though I typed it)


Any idea what I can do about this?

Thanks much