This video explains how to Mail merge from Excel. Filter and merge from Excel

This video explains how to filter records in Microsoft Excel before merging them into Microsoft Word’s mail merge feature. The tutor demonstrates how to create a data validation list in Excel and apply the filter function to react to any selection made from the list. Once the filter is applied the tutor explains how to use the filtered data as the data source for a merged document. The Word document refreshes data when opened displaying the new filtered data. This is a Microsoft Excel and Word tutorial covering, how to Mail merge from Excel, mail merge, Filter and merge from Excel, the filter function, data validation and data source.
#msexcel
#msword
#mailmerge

Playlists for this channel:

#itseasytraining

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books

Excel for New Managers

Very cheap E_books are here:

[waldguy]

I was looking for a way to push the filtered results to Word using an Excel Macro. This will fit the bill nicely. Thanks.

[giakokhreidze]

hi, very nice. But ! You forgot to mention that FILTER fonction just works only in office 365 or 2021 only :(