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

[@ITsEasyTraining1st]

Filter records in Excel and merge them into a Microsoft Word mail merge document. Filter function and data validation. Check out courses at: www.itseasy.co.uk or online at: www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB

[@EasyMSProject]

This is really useful for me, thanks

[@ITsEasyTraining1st]

Thanks

[@ASEmastermechanic]

Hi I wanted to ask a question. At 0:25, we can see it shows title, first name, surname, address, etc. But when the pop up box shows up to do the merge 1:00, the order is different. Surname, Firstname, etc. I know you can drag and drop, but how can you have the 2nd pop box show the same order as in the first one? I moved them around so they match the same order than the 1st box, but if I close and re-open, it goes back to the wrong order.

[@ITsEasyTraining1st]

It is because I used the Address Block feature which is formatted that way.

[@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.

[@ITsEasyTraining1st]

You are welcome

[@EasyGoogle]

I will use this

[@ITsEasyTraining1st]

i do too

[@libreofficetutorials9499]

Cool

[@ITsEasyTraining1st]

Thanks

[@grannysaxton9568]

A good idea

[@ITsEasyTraining1st]

Thanks

[@EasyMSAccess]

A quick way of doing it

[@ITsEasyTraining1st]

thanks

[@giakokhreidze2793]

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

[@ITsEasyTraining1st]

Yes, you are right