God bless you abundantly. I am now inspired to record my own videos of things i previously thought no one would ever need. But here I was looking for this video for weeks.
You prolly dont care at all but does someone know a trick to get back into an instagram account..? I was dumb lost my password. I would appreciate any assistance you can give me
@Ben Jay I really appreciate your reply. I got to the site through google and im waiting for the hacking stuff now. I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
Excellent video, pretty strait forward! I have a question. Is there a way to copy multiple paths from Google drive (eg jpeg phoyos) quickly to the attachments column?
Thanks for the response. I was actually able to send only 50 emails by using this method. Perhaps it displayed for the premium version for more than 50 emails. And yes we can send 500 emails directly through Gmail.
for some reason, my files are not attaching. I followed the instructions exactly. the files are in google drive and when I select, they do not get added to the google sheet! help, any suggestions.
Can anyone tell me why gmail magnify my attachments by 10x. When I send an email two lines text and 2 photos 5MB total the email outgoing is 50MB. Why and what to do?
I believe Gmail allows 500 emails a day, but the add-in I'm using, for the free account, only allows 50 a day. The paid allows a lot more, maybe unlimited.
From Google's support pages. " _You may see this message if you send an email to a total of more than 500 recipients in a single email and or more than 500 emails sent in a day._ " So 500 sounds like the limit.
There are outside applications that work with Gmail that handle this. I have no recommendations since I haven't tested them. Here is one of a few I found that claims they can do what you are asking. support.yet-another-mail-merge.com/hc/en-us
Hello, how are you? Just wondering if there is a way that we can send an attachment based on its file name? For example, if we have a column in our mail merge google sheet as 'Customer Numbers', and the PDF is named 'Customer number'2016, is there a way we can automatically search that and send the attachment without having to select the PDFS for say 200 customer emails? For example, customer number is 1234, and the PDF file would be 12342016. Can we get that to automatically populate the link based on the file name to send to that customer? Thanks heaps :)
No, they are each getting a different PDF, with the filename being their customer number followed by the year. i.e. Customer 1234 will be sent the PDF named 12342016.pdf?
The problem is Google Drive problem. If I have a file named 12342016.pdf and get the link for it, it give me that crazy code. Example: drive.google.com/open?id=0B84qterereeere333$$$$QOHlxT0k If it gave me drive/google/Customers/1234206.pdf with the file name and folder structure, I could get it to probably get it to work with a Concatentate function.
This method is not useful for different attachments with few hundred names. You need to look for each individual attachment address to input into the sheet. That is murdering task.
God bless you abundantly. I am now inspired to record my own videos of things i previously thought no one would ever need. But here I was looking for this video for weeks.
Thank you.
You prolly dont care at all but does someone know a trick to get back into an instagram account..?
I was dumb lost my password. I would appreciate any assistance you can give me
@Charlie Alec instablaster ;)
@Ben Jay I really appreciate your reply. I got to the site through google and im waiting for the hacking stuff now.
I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
@Ben Jay It worked and I finally got access to my account again. I'm so happy!
Thank you so much you really help me out :D
Thank you so much Chris for your great video, you saved my day!
Thanks! This saves me from forwarding every separate attachment I get emailed to a different person each time.
Glad it worked for you!
Thank goodness for this video. All the other DO NOT have this explanation.
Wow, this is exactly what I have looking for. Didn't know it was possible. Great explanation. Thank you!
Thank you.
Great and short video! Thank you for share your knowladge
Thank you!
Excelent ❤️❤️. This is all time free?
Thank you very much Chris
You are very welcome
This. Is. Amazing. Thank you!!!
Thank you.
Outstanding Chris....thank you very much!
Glad it worked. Have a good weekend.
Thanks So much for the tutorial...
"Thank you for your time..",
No... Thank YOU for YOUR time....
You're welcome!
Thank you for your time and sharing. Really enjoyed it and it's very professional!
Thanks again!
Bless you
Thank you very much!
Thank you, very helpful indeed.
You're welcome!
Thank youuu you save my lifeee
Not sure about that, but I appreciate the positive feedback. :-)
excellent. Thank you for this video
You are welcome!
Thanks, good explanation it is nice and easy
Thank you.
Great! I love you man! You save my life!
UA-cam creator and lifesaver. That's me! :-)
Excellent video, pretty strait forward! I have a question. Is there a way to copy multiple paths from Google drive (eg jpeg phoyos) quickly to the attachments column?
Fantastic - what a time saver
Thank you, Diana.
Thank you very much! It was really very helpful!
How many emails can we send at once..?
Thank you so much for this video. It helped me a lot.
You can send 500 per day with Gmail.
Thanks for the response. I was actually able to send only 50 emails by using this method. Perhaps it displayed for the premium version for more than 50 emails. And yes we can send 500 emails directly through Gmail.
@@archanashet5 there is a limit of the free version and I think you are correct that it is 50.
Great video! Thank you very much!
Thank you, Reginaldo.
@@ChrisMenardTraining Your video helped me a lot! So, I'm very grateful to you!
Not able to add any signatures please help!! 😢😢
Really well explained. Thank you.
I appreciate the feedback. Thank you.
Thank you so much Chris, work gets really simple with this, but are these addons secure ?
for some reason, my files are not attaching. I followed the instructions exactly. the files are in google drive and when I select, they do not get added to the google sheet! help, any suggestions.
thanks to this vedio was very useful
You are most welcome
Hallo Chris !
What should I do when, by atteching file pop-up says google-drive is refusing to connect the spredshit. or else computer dictionary too.
I was so excited to use this! Turns out that this app has a daily limit of 25 emails per day and I needed to send 150 :( Did I install the wrong app?
Thanks a lot .
Glad to help.
Thank very much!!!It's very helpful.
Hi. When I click on "ad on", I don't see "create new". Instead I see; "Enable mail merge", "restore license" and "help".
exactly somebody pls help out with this
This is nice but I need to send a different attachment for each recipient, 250 of them. They are certificates of participation. Please help. Thanks!
I got this done with YAMM add-on (Yet Another Mail Merge) for Google Sheets
Thanks for posting!
No problem. I hope it helped.
Can anyone tell me why gmail magnify my attachments by 10x. When I send an email two lines text and 2 photos 5MB total the email outgoing is 50MB. Why and what to do?
How many mails can we send per day???
Is there a limit ?
I believe Gmail allows 500 emails a day, but the add-in I'm using, for the free account, only allows 50 a day. The paid allows a lot more, maybe unlimited.
@@ChrisMenardTraining ya, I already tried. Its awesome. Its the best add-on
What is the limit of sending mails ya? Isit can be send up to 500 per day for free?
From Google's support pages. " _You may see this message if you send an email to a total of more than 500 recipients in a single email and or more than 500 emails sent in a day._ " So 500 sounds like the limit.
@@ChrisMenardTraining has the name of that particular mail merge add-on changed? I couldn't find it. Thanks for the detailed explanation. It helped
awesome sir!!! thanks a lot!!!
I'm glad it helped.
Thanks very much, it really helps :)
Glad it helped.
Any shortcut for file attachments?
hi can i not put a first name and last name?
Can I attach the file from PC.
Thanks sir
you are welcome.
Thank You vry mch.......sir
i trying to send 10 email, but not all email receiving the attachment
i have at least 1000 recipent how do i automatically insert diffrent attachment for them instantly ? not one by one help
There are outside applications that work with Gmail that handle this. I have no recommendations since I haven't tested them. Here is one of a few I found that claims they can do what you are asking. support.yet-another-mail-merge.com/hc/en-us
Many Thanks!!!
Sir give the add-on link plz
how do i send diffrent attachement to different people
At the 02:17 mark is where you specify what attachment or attachments each person receives.
Hello, how are you? Just wondering if there is a way that we can send an attachment based on its file name? For example, if we have a column in our mail merge google sheet as 'Customer Numbers', and the PDF is named 'Customer number'2016, is there a way we can automatically search that and send the attachment without having to select the PDFS for say 200 customer emails? For example, customer number is 1234, and the PDF file would be 12342016. Can we get that to automatically populate the link based on the file name to send to that customer? Thanks heaps :)
In your example, are the 200 customers getting the same PDF?
No, they are each getting a different PDF, with the filename being their customer number followed by the year. i.e. Customer 1234 will be sent the PDF named 12342016.pdf?
The problem is Google Drive problem. If I have a file named 12342016.pdf and get the link for it, it give me that crazy code. Example: drive.google.com/open?id=0B84qterereeere333$$$$QOHlxT0k If it gave me drive/google/Customers/1234206.pdf with the file name and folder structure, I could get it to probably get it to work with a Concatentate function.
This method is not useful for different attachments with few hundred names. You need to look for each individual attachment address to input into the sheet. That is murdering task.
It's not free , only 4 mails are going