how can i export excel data into a word template?

What I would like to do is to create a template in Word with open fields that can dynamically add data from an excel document.  Is this possible?

In other words, let's say I have an excel doc with personal information for many people, and I want to print that data off in a formatted word document.  Is there any way this can be done so that the Word document can pull up the data from specified fields from the excel doc without having to copy-paste each field individually?

Thanks.
|
Answer
Answer

If you want to deal with all of the records (or more than one of them at the one time). then use mail merge.

 

If you want to make use of a single record at a time, use a userform.

 

See the following pages of Greg Maxey's website :

http://gregmaxey.mvps.org/Create_and_employ_a_UserForm.htm

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated July 9, 2021 Views 11,092 Applies to: