How to mail merge from Excel to Word

In this tutorial you’ll learn how to use mail merge in Word for letters. We will retrieve data from Excel to create the merge. Added bonus lesson of how to create envelopes as well.
SOFTWARE:
melcompton.com...
GEAR:
Lenovo ThinkPad Laptop: amzn.to/2NvXTGU
Dell Monitors: amzn.to/3r0iwte
VIVO Dual Monitor Mount Stand: amzn.to/3bBmJ0f
Logitech Wireless Mouse and Keyboard: amzn.to/2OX7V4g
Powered USB Hub: amzn.to/3bBmCBR
Behringer UM2 Audio Interface: amzn.to/3uUWPNE
Audio-Technica Headset: amzn.to/2Np3Qpl
WC Wicked Cushions Replacement Earpads: amzn.to/3uoihuh
LET’S CONNECT:
Facebook: / therealmelcompton
Twitter: / melissaecompton
LinkedIn: / melissa-compt. .
Instagram: / melissaacompton
NOTE: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue making videos like this. Thank you for your support!
#MelissaCompton #MailMerge #Word

[@kjreuben]

EXCELLENT TEACHER

[@BBPeele]

Thank you for the step-by-step tutorial. This is my first time using mail merge in my many years of using MS Word. You made it so easy to follow.

[@juliechambers389]

Melissa this is a great tutorial and I appreciate the clearly explained steps! Is there a way to add a list of payments to each letter and or use another data source? I have a spreadsheet with subtotaled list of payments from these individuals that I want to add to their individual letter. Don't know how to simplify this process. Their totals are on the letter but I need to show the detail of these totals.

[@MelCompton]

Hello! You can. I will get a tutorial out as soon as I can.

[@davidsookharry8555]

great tutorial ! how did u get that last tab about adobe merge to pdf acrobat .mines missing

[@chiprobisonpharmd-pgxclini253]

Melissa.....my anxiety just faded away. Nicely done !! Did you intend to leave out the [STATE] field from your final address ? ....or did I miss something ?? Dr. Clikk Atlanta

[@coronado4homes]

Thank you, Melissa great tutorial!! I was wondering if I can add Intelligent barcode.

[@Scaw]

@12:20 you say that your outlook client will open when ok is hit. Does this imply that sending emails won't work unless outlook is used? I use gmail and don't have outlook.

[@MelCompton]

That is correct. This is only compatible with Outlook.

[@lepantoslim7058]

how did you have a template in the first place

[@MelCompton]

I created the template from within Word. If you go to file>new you should see templates to choose from.

[@NancyThomas-k6m]

my problem is it did not work in windows 11 as I must be missing something? AN EXCELLENT PRESENTER, THANK YOU.

[@angelynsotirakos]

EXCELLENT TEACH!

[@JudyLatham]

Hi Melissa, I wanted to know why my email option was grayed out? any chance you can help me with that

[@MelCompton]

Hello! Usually this means word doesn't think outlook is the default mail client or there is not email field. I would check the settings to make sure outlook is your default mail client.

[@levisublett8850]

Hello Melissa, Great tutorial. Can you use merge with tables inside a Word doc? Thanks!

[@MelCompton]

Hello! If you are talking about merging 2 table cells into 1 like in Excel then yes. You select the ones you want to merge > right click > merge. If you are talking about something else please let me know.

[@xiaohongwu360]

@@MelComptonhi teacher, this is Sean from China. I have a question, I wanna fill information from a source Excel to another target Excel, how can I do, is any method like word mail merge that I can use? Thank you very much

[@patelsahil7846]

When i select the use an existing list option then select the excle sheet then open the select table but sheet are not show in the table

[@MelCompton]

Hello! Do you get an error or do they just not show?

[@talalchhapra72]

Great content

[@MelCompton]

Thank you! Glad it helped!

[@mhayraestores5193]

its not working on my part.

[@MelCompton]

Hello! are you getting an error?

[@mhayraestores5193]

@@MelCompton there's no error. but as I send it and check my inbox in outlook, there's no email sent to those email addresses.

[@mhayraestores5193]

@@MelCompton I mean sent items in outlook*