EASILY Send Personalized Mass Emails With Mail Merge

[@KenjiExplains]

🔥Take our Microsoft Office Bundle: www.careerprinciples.com/courses/microsoft-office-bundle

[@cheborres1762]

You're so good!

[@ngana05]

From the start, you have been my excel role model, especially with finances

[@KenjiExplains]

Glad to hear you found my videos helpful! Really appreciate the comment :)

[@vasimshaikh6163]

Mail merge is the best option for bulk mailing. Learned that way back in 2006. But still happy to learn more. Thanks

[@sallyho146]

Thank you! Can billing use the method to send monthly billing statements to various customers?

[@milindan1459]

Hi! Was extremely helpful! Loved your Excel for beginners and Financial Analysis playlists! Video request: Precedent Transaction Analysis please!!

[@captain_emman9376]

This is a neat trick. Do you know if you send attachments using this method? I would love to see a tutorial on how to send emails from excel using different email brands, yahoo, gmail, outlook in one excel file for a more dynamic system. Great video!

[@KenjiExplains]

yes it's possible if you specify the file path of the files in the Excel file. I'll consider making that in a part 2!

[@elizabethchan9783]

Nice to meet you in the KZbin to solve problem, May I know how to add one more category name in the Treemap ----- Please

[@vannakr25]

Kenji - how would you send a mail merge from a shared inbox or a group inbox? this mail merge only works with a "default" or a personal email. I even switched a shared inbox as a "default" from my personal - still no luck. Any suggestion?

[@arih32]

Hi Kenji. It was a good tutorial. If there is any method to use gmail instead using outlook, kindly guide us

[@ashincholiya]

Hello Kenji, Is there a way to club the data for the same recipient in one email, so that we are not sending multiple emails to the same recipient. I am trying to solve another similar problem

[@t.tmacheng8552]

What if I want to send a different attachment for each receipient. Let's say Monthly Customer statement, can I use the same technique so it attaches a specific PDF for each supplier?

[@KenjiExplains]

It's possible if you specify the file path of the files in the Excel file. I'll consider making that in a part 2!

[@coolkidz33]

Awesome video as always. I have used mail merge but wanted to know if there is a way to customize the subject line for each person. Maybe adding the customer name in the subject line for each email. Do you know if this can be done?

[@cokeromobolatimeless]

Thanks Kenji for your amazing lessons. Can we merge amd send as PDF yet? If yes, kindly share, and if No, are there any tricks you recommend?

[@KenjiExplains]

yes it's possible if you specify the file path of the files in the Excel file. I'll consider making that in a part 2!

[@cokeromobolatimeless]

I will be eagerly waiting. Thank you very much

[@Dmytro848]

Immediate thumb up for F1 drivers' return to Kenji's videos 🙌

[@Mali-cz5sq]

Great video Kenji, what if I wanted to send as a PDF document on email

[@KenjiExplains]

yes it's possible if you specify the file path of the files in the Excel file. I'll consider making that in a part 2!

[@karanmalhotra1308]

Hey Kenji just wanted to check how can we do it if we want to attach some attachments like an excel sheet or PDF

[@motopelamohapi4152]

Mind blowing stuff, thank you, Kenji.

[@KenjiExplains]

Great to hear that! Thanks for your comment :)

[@kalindiya]

If I press send, it uses automatically my personal accout. How if I want to send it from team shared mailbox, because this is how we communicate with our internal customers? How can I set up sending mailbox? Thanks for great tutorial!

[@AzuOnuoha]

Can one use this for multiple letters

[@hassaniftikhar7910]

Can we use a different mailing platform like gmail?

[@lavinokalio]

Can we cc with mail merge? And set security?

[@HarshRaj-t6n]

Kenji, Could you please suggest a industry level project for business analyst role. Or you could make a video including list of projects to get hire from big 3 and big 4 firms. It would be very helpfull.

[@HarshRaj-t6n]

But for now please suggest a project. Thank you:)

[@vivek7517-f7k]

Hii Kenji !!! There is problem in dynamic mail merge Kenji! In conditional message it will not show bank name automatically. It will show bank name if we put it in the message. So basically only one name or no name!!!

[@rohits4413]

Can you please make video on how to prepare excel sheet for this ? What data do we need ?

[@omarhaynes1609]

Literally the information that you want within the letter and email address. It's more or less a standard mail merge without the printing of letters

[@rohits4413]

Kenji, Can we change Subject line for each email ?

[@KenjiExplains]

Don't think so unfortunately (at least I haven't found a way

[@hinata6757]

what if I want it as an attachment then I have a draft email then I will send it together. Also, we need your tutorial on how to set up word to outlook (specially when we use Gmail platform)

[@ksumar]

Nice one Kenji, I quite like the condition variant of sales < or >.

[@KenjiExplains]

Glad it was useful!

[@camlex6310]

This is really cool and helpful!! Thanks

[@nkechiizeji]

Thanks for awesome videos.

[@philvuk]

Awesome video as usual… we want more of it ;))

[@lewis8983]

New Kenji video = easy click!

[@ratulmitra347]

Great video.... I learned a lot from this....

[@KenjiExplains]

Glad it was helpful!

[@Maximillian_536]

I'm from Nigeria. Kenji is my Excel Model.

[@yangkin]

What if I want to put a person's name subject line for each person?

[@UtkarshKumar-mp2ls]

Great kenji

[@stark3221]

Bro can you tell me how can i get internships, i am in 2nd year of my college degree pursuing bcom hons

[@ImmaSarah]

emails are spammed on client side how to fix please

[@willzinner8813]

is this new? didn't njow it existed very cool thanks

[@KenjiExplains]

Not new but perhaps not that known!

[@iamgolden55]

Is this restricted to only outlook

[@muhammadhasanraza1606]

great, keep it up

[@DasBabu1]

Tnq kanji❤

[@artofandrewguerrero]

it doesn't do anything for me. Once I click finish and merge , then send email and okay, it don't do anything. I set myself as the recipient via another account and it didn't receive anything.

[@DigitalTrade24747]

Thanks

[@tassos2011]

When using the rule, the text for the “else” section shouldn’t include the bank name as this should be dynamic for each individual - not sure how you can do it in this example

[@SportsHunterArea]

Create video on click product picture add price of that product to total For example: click pizza picture 🍕 add price of pizza to the Total price

[@jayantsingh9978]

!!!!!!!!!Warning!!!!!!! I found an error kindly resolve it. In the if else rule in timeline 5:30 tge otherwise insert the text will copy the bank name as Barclays to every condition where the commission amount is greater than 4000...... also the bank name does not change as per different people 5:29 after this step

[@UpdateInformativeVideosPK]

emails are going into spam box

[@santhoshmurali7682]

👍

[@KenjiExplains]

1st comment thank you haha

[@divyv20]

Hey Kenji , really nice video ! I was wondering if I could help you with more Quality Editing in your videos , make a highly engaging Thumbnail and also help you with the overall youtube strategy and growth ! Pls let me know what do you think ?

[@UtkarshKumar-mp2ls]

Great kenji

[@KenjiExplains]

Thank you!