From the course: Word: Mail Merge in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Merge with Excel data

Merge with Excel data

From the course: Word: Mail Merge in Depth

Start my 1-month free trial

Merge with Excel data

“

- [Instructor] If your organizations like the organizations I work with, you probably have lots and lots of data hanging around in Excel spreadsheets and the reason is easy to understand. Excel is relatively easy to use compared to other databases and it's very powerful and it's a great export tool. So we have lots of data that started out somewhere else and now ends up in Excel and I'm going to show you how to use data from Excel with mail merge. I'm going to use an existing list. Go to my workbook. Catalog request. It has two worksheets in it. Call request and catalog request. We're going to use catalog request, but before we do this, I want to show you these two sheets because they're going to give us very different outcomes. This is catalog request and it is designed exactly as we would like to have a sheet designed for use with mail merge. Our very first row is headings and so when we're knocks on Excel's door and…

Contents