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!
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?
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
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?
!!!!!!!!!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
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!!!
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?
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)
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.
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!
Hi, I have my Gmail appearing as a email different address, but when I use this Mail Merger, the emails send through as my original Gmail account. How do I make it send the emails as the other Address???
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.
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
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 ?
🔥Take our Microsoft Office Bundle: www.careerprinciples.com/courses/microsoft-office-bundle
You're so good!
Kenji, you are a gifted teacher. Thank you for explaining email mail merge in Word! Now I have to see which client I can use...
From the start, you have been my excel role model, especially with finances
Glad to hear you found my videos helpful! Really appreciate the comment :)
Mail merge is the best option for bulk mailing. Learned that way back in 2006. But still happy to learn more. Thanks
Great new tricks I hadn't used in Mail Merge before.
Thank you Kenji.
Hi! Was extremely helpful! Loved your Excel for beginners and Financial Analysis playlists! Video request: Precedent Transaction Analysis please!!
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!
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!
Mind blowing stuff, thank you, Kenji.
Great to hear that! Thanks for your comment :)
Awesome video as usual… we want more of it ;))
Immediate thumb up for F1 drivers' return to Kenji's videos 🙌
Nice one Kenji, I quite like the condition variant of sales < or >.
Glad it was useful!
This is really cool and helpful!! Thanks
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?
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!
Hi Kenji. It was a good tutorial. If there is any method to use gmail instead using outlook, kindly guide us
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
Thanks for awesome videos.
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?
Great kenji
Hey Kenji just wanted to check how can we do it if we want to attach some attachments like an excel sheet or PDF
Nice to meet you in the RUclips to solve problem, May I know how to add one more category name in the Treemap ----- Please
Great video.... I learned a lot from this....
Glad it was helpful!
Thank you! Can billing use the method to send monthly billing statements to various customers?
Can we use a different mailing platform like gmail?
Can we cc with mail merge? And set security?
!!!!!!!!!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
Can one use this for multiple letters
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!!!
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?
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)
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.
But for now please suggest a project. Thank you:)
is this new? didn't njow it existed very cool thanks
Not new but perhaps not that known!
New Kenji video = easy click!
Tnq kanji❤
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!
What if I want to put a person's name subject line for each person?
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?
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!
I will be eagerly waiting. Thank you very much
Hi, I have my Gmail appearing as a email different address, but when I use this Mail Merger, the emails send through as my original Gmail account. How do I make it send the emails as the other Address???
Can you please make video on how to prepare excel sheet for this ? What data do we need ?
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
great, keep it up
emails are spammed on client side how to fix please
I'm from Nigeria. Kenji is my Excel Model.
Great video Kenji, what if I wanted to send as a PDF document on email
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!
Kenji, Can we change Subject line for each email ?
Don't think so unfortunately (at least I haven't found a way
Thanks
Bro can you tell me how can i get internships, i am in 2nd year of my college degree pursuing bcom hons
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.
Is this restricted to only outlook
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
emails are going into spam box
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
👍
1st comment thank you haha
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 ?
Great kenji
Thank you!