Mail Merge with Word and Excel

In this tutorial, I'll show you step by step how to mail merge with Word and Excel. First, we create a simple list of names and addresses in Excel. We then create a mail merge document and then we'll use the Mail Merge Wizard from Word to generate personalized documents with data from the spreadsheet inserted automatically.
#mailmerge #excel #word #microsoft
~-~~-~~~-~~-~
Please watch: "Excel Top 5 Flash Fill Excel"
• Excel Top 5 Flash Fill...
~-~~-~~~-~~-~

Пікірлер: 14

  • @OfficeMystic
    @OfficeMystic2 жыл бұрын

    Subscribe for more! tinyurl.com/mu8f835c I am returning to this channel after a LONG hiatus; if you enjoyed this video, please subscribe and drop a suggestion below for future videos or if you have a general MS Office question. I would appreciate the subscription immensely! Thank you for your time.

  • @zafarrizvi
    @zafarrizvi2 жыл бұрын

    Your video is so simple and easy. Thank you so much to not make a long video. You are great! I watched couple of videos but couldn't get any help from them.

  • @OfficeMystic

    @OfficeMystic

    2 жыл бұрын

    Thanks for the feedback! I'm glad it was helpful.

  • @typhoonjunior3358
    @typhoonjunior33582 жыл бұрын

    Nice movie

  • @moniqueowens7726
    @moniqueowens77262 жыл бұрын

    How do you save the finished mail merge to separate documents?

  • @OfficeMystic

    @OfficeMystic

    Жыл бұрын

    There isn't a way to do it with the built-in Word feature, but here is a link to a page in how to do it with a macro: www.msofficeforums.com/word-vba/42482-mail-merge-split-merged-documents-rename-each.html

  • @ThusIsBrad
    @ThusIsBrad4 жыл бұрын

    Why do you put # before the dollar sign?

  • @OfficeMystic

    @OfficeMystic

    2 жыл бұрын

    I regret the delay. I stepped away from the channel for quite some time, and I'm sure you already have your answer, but I don't want to leave a question unanswered just in case someone else drops by with the same question. The "\#" is a switch to tell Word that the data is being pulled in a number format.

  • @MarquiseParker2007
    @MarquiseParker20074 жыл бұрын

    I don't see the mailings tab

  • @pabloedpaula

    @pabloedpaula

    3 жыл бұрын

    Do you fix it later? I have the same problem today after watch this video

  • @brianchu8147

    @brianchu8147

    3 жыл бұрын

    Different ver of word put the function in different places. For me, I have Mac 2011 ver and so I go to "Tools" menu drop down > Mail Merge Manager

  • @OfficeMystic

    @OfficeMystic

    2 жыл бұрын

    Office Mystic 1 second ago I regret the delay. I stepped away from the channel for quite some time, and I'm sure you already have your answer, but I don't want to leave a question unanswered just in case someone else drops by with the same question. You can try right-clicking on any of your other tabs, select customize ribbon and you should see an empty checkbox next to "Mailings" if you still don't see it, you might be able to transfer it over from the column of tools on the left side of that same window.

  • @reii8632

    @reii8632

    2 жыл бұрын

    @@OfficeMystic im crying over a mail merge😭 i still cant find it, i am currently making a mail merge for my final exam, its stressing me out

  • @OfficeMystic

    @OfficeMystic

    2 жыл бұрын

    @@reii8632 what version of word do you have? Are you on Windows or a Mac?