View Single Post
 
Old 04-10-2012, 04:03 PM
iiiiifffff iiiiifffff is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Apr 2012
Posts: 5
iiiiifffff is on a distinguished road
Default Macro to find text and replace with form field containing that text

Hi,
I am in over my head here, and I am hoping that someone on this forum can help me out...

I have a series of documents that were created with a mailmerge and contain several copies of the same form (using legacy forms because some of our computers are still running Word 2003/2004), but for different students' names and info at the top of each page (I am a teacher). Eventually, I hope to export the form data to Excel, but I need some of the info inserted in the mail merge to be converted to form fields. Here's what I am thinking the macro needs to do:

1. Find the string "Student #:"
2. Select the next word to the right (i.e. the student number)
3. Cut this word
4. Insert a text form field pre-populated with the cut text
5. Repeat for all instances in the document

I would really appreciate any help than anyone can give me here.

Thanks,
Ian
Reply With Quote