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?
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?
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?
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, 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.
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)
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!!!
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!
!!!!!!!!!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
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!
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 :)
Great new tricks I hadn't used in Mail Merge before.
Thank you Kenji.
Mail merge is the best option for bulk mailing. Learned that way back in 2006. But still happy to learn more. Thanks
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 :)
Immediate thumb up for F1 drivers' return to Kenji's videos 🙌
This is really cool and helpful!! Thanks
Hi Kenji. It was a good tutorial. If there is any method to use gmail instead using outlook, kindly guide us
Awesome video as usual… we want more of it ;))
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!
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?
Thank you! Can billing use the method to send monthly billing statements to various customers?
Nice to meet you in the TH-cam to solve problem, May I know how to add one more category name in the Treemap ----- Please
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!
Nice one Kenji, I quite like the condition variant of sales < or >.
Glad it was useful!
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
Thanks for awesome videos.
Great video.... I learned a lot from this....
Glad it was helpful!
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
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
New Kenji video = easy click!
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:)
Hey Kenji just wanted to check how can we do it if we want to attach some attachments like an excel sheet or PDF
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)
I'm from Nigeria. Kenji is my Excel Model.
Can we use a different mailing platform like gmail?
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!!!
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
Can one use this for multiple letters
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!
Tnq kanji❤
Can we cc with mail merge? And set security?
is this new? didn't njow it existed very cool thanks
Not new but perhaps not that known!
What if I want to put a person's name subject line for each person?
great, keep it up
!!!!!!!!!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
Kenji, Can we change Subject line for each email ?
Don't think so unfortunately (at least I haven't found a way
emails are spammed on client side how to fix please
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.
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
Thanks
Is this restricted to only outlook
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
emails are going into spam box
👍
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!