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
Most popular video at the moment: Spill error, • Spill Error in Microsoft Excel
If you want to support me, check this out: / itseasy
Playlists for this channel:
Access: • Unleash the POWER of SUBMACROS in Acc...
Excel: • Link web based data into Microsoft Excel
Word: • How to use Microsoft Word's mail merg...
Visio: • How to create a basic network diagram...
Project: • How to use Baselines and custom repor...
PowerPoint: • Zoom feature in Microsoft PowerPoint,...
Publisher: • How to set or create Business informa...
OneNote: • OneNote Overview, linking into Outloo...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv