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/
🔥🔥🔥 WIN A SAMSUNG GALAXY A10 HERE : https://youtu.be/3vamWTYv3Mk
CONTEST IS VALID TILL DECEMBER 22, 2019
Thanks !!! This video was very helpful – excellent job.
Is there anyway to make a mail merge from Excel to Excel?
Hii
Thanks it helps me for my exams…
Thank you so sooo much 🥰🥰
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.
Thank u that was so helpfull now i can understand more about mail merge
Thank you for this, extremely helpful at the last hour :):):)
❗ Subscribe To Our Main YouTube Channel
https://www.youtube.com/user/howtechpc
Can we save excel file in document?
Good explanation. Thanks!
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!
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).
Very helpful…tq so much…
thanks alot man <3
nigga saved my life
This was helpful!
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
thank you 2morrow is my exam now i can write these thank you
simple soluble and digestive.exactly what i was looking for.
Thanks. That was simple and quick 🙂
Thank You
This video is nice and beautiful <3 I <3 it
nice and simple thanks
that's ms word mail merge. not excel mail merge.