Great lesson. Had no idea there was a mail merge option there. 🤓
@FlippedClassroomTutorials Жыл бұрын
I'm glad to hear you found it helpful.
@clayclay957 ай бұрын
I love the way you go straight to the point! Quite helpful info. Thank you so much 👍
@MaryCarey-e3p23 күн бұрын
Brilliant and thank you
@FlippedClassroomTutorials22 күн бұрын
You're welcome!
@dilipchainani4712 Жыл бұрын
Thank you for the update. It will be of great help in doing office work specifically communication with large number of students
@FlippedClassroomTutorials Жыл бұрын
Absolutely!
@ScienceAbroadАй бұрын
Super helpful and so simple. Thank you
@FlippedClassroomTutorialsАй бұрын
Glad to hear that!
@ScienceAbroadАй бұрын
@@FlippedClassroomTutorials Is there an easy way to add individual attached files using this (or another) feature?
@dianak.hernandez3883 ай бұрын
Very helpful! Thank you so much. I'll suscribe 🙂
@FlippedClassroomTutorialsАй бұрын
Brilliant! Welcome to the community!
@mariaj.bradshaw1628 Жыл бұрын
Hi, I was so happy to see your presentation but I do not have the merge button in my "To" field and I could not figure out why not. Can you help, please?
@FlippedClassroomTutorials Жыл бұрын
This could be due to the workspace edition you are using. Not all versions will get access to this. The list of supported versions is shown at the start of the video. Hope this helps.
@mariaj.bradshaw1628 Жыл бұрын
Thanks for your prompt answer, I see it only works in case someone has Google workspace. @@FlippedClassroomTutorials
@FlippedClassroomTutorials Жыл бұрын
Correct and the workspace individual subscription.
@jutetwine44828 ай бұрын
thank you for sharing this, just what I need for my work. Very useful tool indeed!
@FlippedClassroomTutorials7 ай бұрын
Glad it was helpful!
@MyMamaDreams13 күн бұрын
Thank you, this is very helpful. My only issue here is that when I change the image and send the email, that image appears in the body of the email but also at the bottom as an attachment. Do you know how to stop the attachment to show at the end?
@iesamurojrin Жыл бұрын
Awesome as usual. Thanks a lot !
@FlippedClassroomTutorials Жыл бұрын
Thank you!
@thangavelurajАй бұрын
This feature is not appearing in our Gmail? We use paid gmail services with our own domain name, is this the reason?
@FlippedClassroomTutorialsАй бұрын
To use mail merge, you need to be on an eligible Google Workspace plan: Workspace Individual Business Standard Business Plus Enterprise Standard Enterprise Plus Education Standard Education Plus Hope this helps. If you are on one of these, and still do not see it, I would reach out to your admin or support.
@user-db6qw3hd9i Жыл бұрын
Great tutorial. Question: I'm using Workspace to send bulk personalized emails from data that's in a Google Sheet. I want to embed a personalized link to a pre-filled Google form in each email. The links aren't working right for me. In Sheets, they all work properly. But when I paste the link into the Gmail, they no longer work. How do I do this?
@EileenMarie10 ай бұрын
This is great but if you are not the admin, you cannot change the settings and activate this function.
@S0912S8 ай бұрын
do you mean local computer admin? I dont see this option on my laptop, or settings to change it
@FundStory Жыл бұрын
How to send reminders based on different dates to different persons in a spreadsheet/Google sheet
@bindaaslyfe Жыл бұрын
Great work, stay blessed 👍
@FlippedClassroomTutorials Жыл бұрын
Thank you! You too!
@RobertForbes-bp1pq2 ай бұрын
How to send to a select group from within a spreadsheet? I don't want to send to everyone in the list IE: certain recipients might need a reminder of fees due.
@PILINISESI87Ай бұрын
I am running into this message not sure what I did wrong. "Check the email column Make sure there are no missing emails, and every email is in the right format"
@mkallers5 ай бұрын
Great video! What about adding some one to the cc field?
@FlippedClassroomTutorials5 ай бұрын
By default all addresses are added to the bcc field. You can only have one recipient in the "Cc" or "Bcc" field in each message with mail merge. Any recipient added to the "Cc" or "Bcc" field is copied on each outgoing email. More info: support.google.com/mail/answer/12921167#zippy=%2Cunderstand-cc-and-bcc-recipient-limits
@wingsluxe2 ай бұрын
BRILLIANT. Thank you
@FlippedClassroomTutorialsАй бұрын
You're welcome!
@antoniogabrieletrifone340811 ай бұрын
Great video thanks! But I can not see the mail merge icone! Do you know why? Many thanks
@FlippedClassroomTutorials11 ай бұрын
Could be that you are on a different version of workspace. Have a look in the description and video for the versions that are supported. Alternatively I would reach out to the workspace domain admin.
@antoniogabrieletrifone340811 ай бұрын
@@FlippedClassroomTutorials thanks for your time!
@FlippedClassroomTutorials11 ай бұрын
Always :-) I'm glad you enjoy the videos. Hopefully you find others just as helpful
@4thstage220 Жыл бұрын
Great job as always... What's the daily limit?
@FlippedClassroomTutorials Жыл бұрын
Excellent question. From Google: Standard Gmail accounts have a daily send limit of 500 outgoing messages. Work, school, and Workspace Individual accounts have a daily send limit of 2,000 outgoing messages. With mail merge, you can: Add up to 1,500 recipients in the “To” line per message Send to a maximum of 1,500 recipients per day With mail merge on, you can send one message to 1,000 recipients and another message to 500 recipients. The 1,500-recipient daily limit for mail merge ensures that you can still send up to 500 normal messages per day and not exceed the 2,000-per-day limit for work, school, and Workspace Individual accounts.
@Hari_1995-y4k10 ай бұрын
Thanks for this, its great
@user-yz3so9hy2o5 ай бұрын
hey thansk for the video, how did you add the unsubscribe button in the gmail?
@rahimcasskarenga48056 ай бұрын
I have a business email but I can't enable the mail merge function.. Any help?
@laisonkc6 ай бұрын
How can i attach the multiple personalised attachmet for each receipient ?
@robinmanly7381 Жыл бұрын
Will this also work if you use something like Mailtrack Pro along with Gmail?
@FlippedClassroomTutorials Жыл бұрын
I am unfamiliar with Mailtrack Pro, but if it uses the same compose window as Gmail, then this should, in theory, work
@mihaitusac6545 ай бұрын
How can we make a delay between each email and have be sent at a fixed or variable rate?
@FlippedClassroomTutorials5 ай бұрын
That feature is not built into this system.
@duranchula8585 ай бұрын
Great explanation. Will the recipient receive the email individually or they will see others email added in the google sheet? Will it be private?
@FlippedClassroomTutorials5 ай бұрын
They will receive it individually, similar to using the bcc field. So they won't see the other emails addresses.
@textube7710 ай бұрын
Thanks. Is there a limit of email numbers to merge?
@shejiiahshinjiru88495 ай бұрын
Hey, was wondering where'd you get the mmail merge? Is it from chrome webstore that act as extension to gmail?
@FlippedClassroomTutorials5 ай бұрын
No extension here. This is a new feature of Google Workspace for Education Plus
@InHomeTutoringHonoluluАй бұрын
I'm using Workspace and do not have that feature.
@FlippedClassroomTutorialsАй бұрын
Which Workspace edition are you using. Sadly this one is not part of the Free Fundamentals version.
@Royalaffiliategroup2 ай бұрын
I haven’t got that on my emails. I’ve checked all my gmail accounts. Any ideas?
@FlippedClassroomTutorialsАй бұрын
Which workspace edition are you using. Sadly this is not available for fundamentals (Free) workspace or gmail accounts.
@ram_msd9 ай бұрын
Hey how can i schedule email using this method any suggestion?
@Mazzunited88 Жыл бұрын
Hi is there any limit how many emails can be sent? And is it free? Thanks
@FlippedClassroomTutorials Жыл бұрын
Hi. All the information about edition this is available to and the various limits (different for every workspace edition) can be found here: support.google.com/mail/answer/12921167?hl=en#zippy=%2Cunderstand-send-limits Hope this helps 😀
@hasanfanus130Ай бұрын
Dear sir, In this method howmany emails can send at once?
@FlippedClassroomTutorialsАй бұрын
Hi! I'm sharing Google’s official answer here: With mail merge, you can: Add up to 1,500 recipients in the "To" line per message Send to a maximum of 1,500 recipients per day With mail merge on, you can send one message to 1,000 recipients and another message to 500 recipients. The 1,500-recipient daily limit for mail merge ensures that you can still send up to 500 normal messages per day and not exceed the 2,000-per-day limit for work, school, and Workspace Individual accounts. There’s no limit to the number of unique recipients you can contact per month with mail merge.
@hasanfanus130Ай бұрын
@@FlippedClassroomTutorials Thank you sir ❤
@immi1498 Жыл бұрын
Can we do it from smartphone on the go?
@FlippedClassroomTutorials Жыл бұрын
Not at the moment. This feature is not supported in app
@danEthedroid Жыл бұрын
Great tip. How do you put unsubscribe link in gmaail?
@FlippedClassroomTutorials Жыл бұрын
When you turn on mail merge, a unique subscribe link is automatically added to the bottom of each email. Recipients can use this link to unsubscribe or resubscribe to your emails.
@boburs788 ай бұрын
Great video , I dont see extensions.
@saqi1187Ай бұрын
Mail merge is not showing in my compose section
@FlippedClassroomTutorialsАй бұрын
Which version of workspace are you using. This is sadly not supported in the fundamentals(Free) version
@user-oh9zp2bs9q11 ай бұрын
by this method emails are send through bcc or cc
@FlippedClassroomTutorials11 ай бұрын
It uses the To and replaces the emails so effectively the same as bcc
@shamsundar16755 ай бұрын
What to do if that little people icon don't show up?
@FlippedClassroomTutorials5 ай бұрын
To use mail merge, sign in to an account with an eligible Google Workspace plan: Workspace Individual Business Standard Business Plus Enterprise Standard Enterprise Plus Education Standard Education Plus
@MasterTheNEC9 ай бұрын
Mine doesnt have the Mail Merge Option.
@FlippedClassroomTutorials9 ай бұрын
This is part of the premium workspace editions such as teaching and learning upgrade.
@MasterTheNEC9 ай бұрын
@@FlippedClassroomTutorials Thank You. Sadly I do not see the option for the upgrade as I do pay for the 100GB account.
@LifeofMarvellous2 ай бұрын
I hate if the mail merge icon isn’t there?
@FlippedClassroomTutorialsАй бұрын
Which version are you on? the Mail merge is not supported for (Free) fundamentals account in workspace.
@HassanAshour Жыл бұрын
marvelous
@rgbtvuk11 ай бұрын
Can it send out pdf files ?
@FlippedClassroomTutorials11 ай бұрын
You can attach these. Do keep best practices in mind to avoid being flagged as spam. Not many people like receiving pdf's in their inbox. You could add a link to a Drive file? Some peace of mind that Drive has scanned the file.
@3insurichard9 ай бұрын
How can i sent 15,000 email to my students
@virginiaolv3 ай бұрын
Is this business Gmail?
@FlippedClassroomTutorialsАй бұрын
This is the Workspace plus version. As this feature is not available anymore to Free accounts.
@danicamaemendez84255 ай бұрын
Can I send 20k emails at once using this?
@FlippedClassroomTutorials5 ай бұрын
Standard Gmail accounts have a daily send limit of 500 outgoing messages. Work, school, and Workspace Individual accounts have a daily send limit of 2,000 outgoing messages.
@marymichellejomoc4975 Жыл бұрын
I don't see mail merge sir
@FlippedClassroomTutorials Жыл бұрын
Do check the edition of Google Workspace you are using. This is part of the list as shown at the start of the video. Hope this helps