How to do Excel 2007 Mail Merge



Learn how to do excel mail merge

Don’t forget to check out our site for more free how-to videos!
– our feed
– join us on facebook
– our group in Google+

In this video tutorial we will show you how to do excel mail merge.

In order to merge mail, open the Microsoft Word document. Go to the “Mailings” tab. Click on “Start Mail Merge” and choose a “Step by step mail merge Wizard”.

In the 1-st step, choose “Letters” as type of the document and press “Next: Starting document”.
to do excel mail merge.

In this step select “use the current document” and click “Next: Select recipients”. To make selections in 3-rd step, minimize the word document and open your excel document.

Go back to the word document and choose “Browse”.

Select your excel document and press “Open”. In the appeared window select the table with data. In the following window check or uncheck mail merge recipients and click “ok”. Then press “Next: Write your letter”.

In Step 4 — go to the “Mailings” tab, click on “Insert Merge Field” and choose needed values.

Insert it in your document. Next step is “Preview your letters”, click on it.

Now you can see your letter with merges. Click on “recipients” to see the results. Then click “Complete the merge”.

In the following window press “Edit individual letters”.

In the new window select “all” and click “ok”. Now all your letters are placed on separate pages.

Nguồn: https://federicobellucci.net/

Xem thêm bài viết khác: https://federicobellucci.net/tong-hop/


Article Categories:
Tổng Hợp

Comments

  • 🔥🔥🔥 WIN A SAMSUNG GALAXY A10 HERE : https://youtu.be/3vamWTYv3Mk

    CONTEST IS VALID TILL DECEMBER 22, 2019

    Excel, Word and PowerPoint Tutorials from Howtech August 4, 2020 12:16 pm Reply
  • Thanks !!! This video was very helpful – excellent job.

    Crista Patterson August 4, 2020 12:16 pm Reply
  • Is there anyway to make a mail merge from Excel to Excel?

    Flavio Mota August 4, 2020 12:16 pm Reply
  • Hii
    Thanks it helps me for my exams…
    Thank you so sooo much 🥰🥰

    FREE FIRE PRACHET August 4, 2020 12:16 pm Reply
  • I am so afraid I can't see to learn the steps on mail merge especially putting in word document and the excel spreadsheet to do the letter and recipient were the word document is stored or excel spreadsheet you have go back and do the letter.

    Lynette Ford August 4, 2020 12:16 pm Reply
  • Thank u that was so helpfull now i can understand more about mail merge

    JOKER M August 4, 2020 12:16 pm Reply
  • Thank you for this, extremely helpful at the last hour :):):)

    Sadé Ramsamy August 4, 2020 12:16 pm Reply
  • ❗ Subscribe To Our Main YouTube Channel

    https://www.youtube.com/user/howtechpc

    Excel, Word and PowerPoint Tutorials from Howtech August 4, 2020 12:16 pm Reply
  • Can we save excel file in document?

    Anusha N August 4, 2020 12:16 pm Reply
  • Good explanation. Thanks!

    Will Hartman August 4, 2020 12:16 pm Reply
  • This was so helpful!! I've been struggling all morning with doing this and you explained it perfectly in 2 minutes. Thank you, thank you, thank you!

    Cyndie Moore August 4, 2020 12:16 pm Reply
  • Hi, can I get a single document from every page? I must not print, I have to send each page via e-mail…
    Best shoud be to save (or export in pdf) having filename as a selected field from Excel file (i. e. Names col).

    Gaspare Pero August 4, 2020 12:16 pm Reply
  • Very helpful…tq so much…

    Karuna Peddinti August 4, 2020 12:16 pm Reply
  • thanks alot man <3

    Aris Astral August 4, 2020 12:16 pm Reply
  • nigga saved my life

    dhafin anwar August 4, 2020 12:16 pm Reply
  • This was helpful!

    BTS A.R.M.Y August 4, 2020 12:16 pm Reply
  • hi if i want to use excel data base with barcode fromone excel & prepare variable data challans tamplate in another excel
    How to go about, i have tried using mail merge with word but the barcode in word out put does't read, but the barcode in data base excel reads

    Prasad Datar August 4, 2020 12:16 pm Reply
  • thank you 2morrow is my exam now i can write these thank you

    himanshu jogi August 4, 2020 12:16 pm Reply
  • simple soluble and digestive.exactly what i was looking for.

    Sanjay Meena August 4, 2020 12:16 pm Reply
  • Thanks. That was simple and quick 🙂

    Ajay Chitkal August 4, 2020 12:16 pm Reply
  • Thank You

    Sannareddy Harshavardhan August 4, 2020 12:16 pm Reply
  • This video is nice and beautiful <3 I <3 it

    Trailers & Songs August 4, 2020 12:16 pm Reply
  • nice and simple thanks

    Deshosur Robinsonin August 4, 2020 12:16 pm Reply
  • that's ms word mail merge. not excel mail merge.

    Eko Nugroho August 4, 2020 12:16 pm Reply

Leave a Comment

Your email address will not be published. Required fields are marked *