Extracting data from Excel into Word document.

Question

Hello,  part of my job is to look at a list of patrons (over 162) and write them thank you letters. The biggest time-waster when doing this is putting down their information (name, salutation, address, zip code, etc.) and was wondering if there was a quicker way to do it. Up to this point I have been copying and pasting (sometimes plain old typing) the information individually, which is a lot of back and forth (not to mention losing my place in the spreadsheet every time). Is it possible to extract the information from the Excel spreadsheet and automatically input the data into the greeting and salutation lines?

Here is the basic layout of the spreadsheet:

Last Name	First Name	Preferred Title	Address	State	Zip Code

Answer 1

Hi Jorge,

Word will work with Excel and do all that automatically for you, it is known as Mail Merge

Since you already have your data in Excel, you already have most of the work done

Click this link for a step by step tutorial on how to mail merge in Word:

https://support.office.com/en-us/article/use-ma...

Answer 2

Have you tried using mail merge with Excel as the data source? It was designed for this sort of thing. :)

Answer 3

Hi Jorge, Glad to Help!

Answer 4

Thank you very much, I will look into this