How to Export data from fields in Excel to fields in Word

[KenWright]

Currently have:-
1 Excel document, 3 Cols * 20 rows:-

Name / App / Criticality
1 AA BB 1
2 CC DD 3
3 EE FF 2
......... and so on

Also have a Word Document with various text on it, but it has 3 blank fields that correspond to Name / App / Criticality, ie each word doc looks like:-

xxxxxxxxx
xxxxxxx
Name
xxxxxxxx
xxxxx
App
xxx
Criticality
xxxxxxxx

How can I use the Excel document to create 20 Word Docs, each with the data from one of the records in the Excel spreadsheet? VBA solution would be great.

Many Thanks
Ken...............

 

[Dreamboat]

Hi, Ken. You know how to mail merge?

http://www.theofficeexperts.com/word.htm

and click on the Mail Merge link.

Unless by "20 Word docs" you mean you need 20 documents of each record in the Excel file.... but I assume you just say "20" because you have 20 records?

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[DaveWoodward]

Hi,

Ken is helping me out with this problem, and now that I have subscribed, I'll be able to continue. Thanks ken.

Problem with mail merge is that the fields in the document are 'lost' when the merge is done. I need to be able to send out the documents, get people to fill them in and send them back to me. Then I need to pull out the data iNCLUDING THE MERGED FIELDS. Into a comma separated file.

Is there a way to do the merge but retain the fields so that I can do 'save data only' later?

Cheers

Dave