Merge Excel data into specific form areas in a Word Doc
 

Alright, if anyone can figure this one out, you'll save me a bundle of
time and teadious typing:) !

If in Excel, I currently have, let's say the following on row "D"

d1 name
d2 address
d3 city
d4 state
d5 zip
d6 account number

And in Word, I have a protected form with 6 text form fields which use
the tab button to move from one text form field to the next.

So let's say the following is true in my protected form in Word...

Text Form Field 1 - name
Text Form Field 2 - address
Text Form Field 3 - city
Text Form Field 4 - state
Text Form Field 5 - zip
Text Form Field 6 - account number

How do I export the Excel data from row "D" to each of the respective
Text form fields in the Form I have from Word?

Thanks so much for anyone's help on this.


--
duugg
------------------------------------------------------------------------
duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372
View this thread: http://www.excelforum.com/showthread...hreadid=534669

Merge Excel data into specific form areas in a Word Doc
 

I can see a couple of ways of doing this.

The first involves the creation of a Word object and driving the
manipulations from Excel

Have a look at

Controlling One Microsoft Office Application from Another

in Excel VBA help.

The other way is to use the Application.SendKeys method to send
keystrokes to word.


--
mrice

Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=534669