Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-10-2012, 04:03 PM
iiiiifffff iiiiifffff is offline Macro to find text and replace with form field containing that text Windows XP Macro to find text and replace with form field containing that text Office 2010 32bit
Novice
Macro to find text and replace with form field containing that text
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
Macro to find text and replace with form field containing that text Form Fields - Create blank form text field with if statement? LAssist2011 Word 5 12-14-2011 03:02 PM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM
Macro to find text and replace with form field containing that text Need help on Macro 03- Find text - if text is blank then remove line simpleonline1234 Word VBA 1 02-25-2011 02:28 AM
Treating a text box like a form Text Field jackaroo Word 0 08-18-2010 10:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft