Send Personalized Emails from Excel using Power Automate

Send Personalized Emails from Excel using Power Automate

Teacher's Tech

6 месяцев назад

36,391 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@IvanCortinas_ES
@IvanCortinas_ES - 13.05.2024 15:51

Great tutorial Jamie.
This part of Power Automate could previously be treated as a plug-in and installed on the Data tab.
It is now by default on the Automate tab.
I imagine that the Attachment part can be implemented from the advanced part, just like you have done with the CC section.
Thank you very much for sharing this information.

Ответить
@Ian.M10189
@Ian.M10189 - 13.05.2024 15:58

Excellent 👍

Ответить
@lisbethgomez1592
@lisbethgomez1592 - 13.05.2024 16:30

Amazing content! Well explained, easy to follow :) Thank you!!!

Ответить
@Anuoluwapo70X7
@Anuoluwapo70X7 - 13.05.2024 17:03

Thank you Sir.
We appreciate you ❤

Ответить
@PeKey-u3c
@PeKey-u3c - 13.05.2024 17:48

.

Ответить
@jeannine1769
@jeannine1769 - 13.05.2024 20:45

Thanks for this video Jamie. Quick question for you since I can't find answer anywhere. Is there a way to automate a weekly reminder email to my team on Outlook? No customization needed. Thanks!

Ответить
@abhishekmulani9567
@abhishekmulani9567 - 14.05.2024 08:31

How to insert email signature to this?

Ответить
@tomahinic8031
@tomahinic8031 - 14.05.2024 13:13

👍👍👍

Ответить
@KimzCraftz
@KimzCraftz - 15.05.2024 18:44

This is useful, thank you. Yes, I would like to see how to do customised attachments also.

Ответить
@ITZ5
@ITZ5 - 16.05.2024 06:12

Loved it!

Ответить
@r.c.453
@r.c.453 - 17.05.2024 18:06

Hi ! does the data need to be filled for all contacts? for example can I have one contact be sent 2 personalised paragraphs and another 5 depending on whether I have the full data for that specific contact? thx!

Ответить
@gmostafaali
@gmostafaali - 18.05.2024 00:45

Thank you for the useful tutorial. If you could make a tutorial with the Power Automate sending certificate to event's attendees.

Ответить
@nelsonacess944
@nelsonacess944 - 22.05.2024 06:56

Can this be set up to send multiple entries to the same address?

Ответить
@bobforbes1231
@bobforbes1231 - 22.05.2024 17:40

Is there a similar feature in Google Sheets? I like this a lot but some of the people i work with do not have 365 but we have the google workspace

Ответить
@rubayetraihan9858
@rubayetraihan9858 - 29.05.2024 13:36

I have some question, please reply or make videos about that.

1. In reminder date, when the email arrived? is there any specific time?
2. If I want to keep any specific mail as CC always, how to do?
3. If I want to send any attachment in mail, how to do?
4. Is this possible to add any company group mail to the mail list so that all the employees can get same mail?

your video is very helpful. thanks.

Ответить
@TraceyWinters-uf4zg
@TraceyWinters-uf4zg - 31.05.2024 15:47

was very useful any tips on power automate welcomed. Also do you have a way to do this but with multiple rowsfor the same person to only send one email. e.g. course fee 1, course fee 2 and overall total?

Ответить
@PeePeeOhanyere-fb6dt
@PeePeeOhanyere-fb6dt - 18.06.2024 00:24

hello , i always turn in to your channel because you are a great teacher, pls can i do flash fill on Microsoft word pls do a video and also a video on how to share scream video

Ответить
@mikecorbean9985
@mikecorbean9985 - 24.06.2024 20:36

Add attachment tutorial video yes please!

Ответить
@mikecorbean9985
@mikecorbean9985 - 26.06.2024 02:29

Absolutely, fabulous content and teaching.

Ответить
@itlmarketing
@itlmarketing - 28.06.2024 12:55

the "For a selected row" trigger is now deprecated and flow no longer works. Any workaround available

Ответить
@nadiaquinonez8085
@nadiaquinonez8085 - 03.07.2024 05:34

I created the FLOW but did not work for me :(

Ответить
@ponchbass
@ponchbass - 12.07.2024 18:15

Is not working anymore, any other option?

Ответить
@chrisarce901
@chrisarce901 - 16.07.2024 19:55

Hi there,

Thanks for this tutorial. While in the process we encountered this error. Can you help us sorting this one out? Thanks!'

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Integer.,Invalid type. Expected String but got Integer.'.

Ответить
@nazikcam9148
@nazikcam9148 - 18.07.2024 10:27

Thanks a lot sir! It was very clear tutorial and helped a lot.

Ответить
@martinagiven7024
@martinagiven7024 - 20.07.2024 01:14

this option is now depreciated in Power Automate, is there another template or option we can use to perform the same step/automation?

Ответить
@agunslinger9349
@agunslinger9349 - 30.07.2024 20:56

Nice video. My O365 says "For a selected row, complete a custom action" is Deprecated.

Ответить
@RobertStuckey-m6r
@RobertStuckey-m6r - 13.08.2024 21:25

Does anyone know why this template has been randomly marked as "Deprecated"? Any alternative if it's removed? Was just about to adopt this for a major project at work and now worried we'll loose access.

Ответить
@alexIgp-g5o
@alexIgp-g5o - 22.08.2024 10:41

On the make.powerautomate page, there is a note that the template is outdated. Does anyone know which template is being used instead?

Ответить
@ElzaiD-h6x
@ElzaiD-h6x - 04.09.2024 17:44

Really helpful, how do I edit where the email is coming from? I would like the email coming from a general mailbox. Thanks.

Ответить
@nicoleeclemente
@nicoleeclemente - 05.09.2024 17:49

This is great but I also want to learn how to connect my paid ChatGPT to help create draft email responses? I have the API key but I need help!

Ответить
@shahbaz7231
@shahbaz7231 - 30.09.2024 12:41

hi, this template has been deprecated, can you make a video showing how to message 100 people from Excel to MS Teams using Power Automate please?

Ответить
@AiskrimLangit
@AiskrimLangit - 06.10.2024 15:36

Hi, if i do click the send. can i actually preview the email first before send it?

Ответить
@simonec98
@simonec98 - 06.10.2024 19:31

Can anyone tell me how to do this with automate? Thanks! I have an Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).

Ответить
@ivanbork4175
@ivanbork4175 - 18.10.2024 13:42

A good video, with a good topic that is useful in everyday life, and you present it with clear and concise speech, and not least at an appropriate pace.
Thanks.

Ответить
@engamalamer8122
@engamalamer8122 - 22.10.2024 12:37

Thaaaaaaaaaaaaanks a lot , it is what I need :)

Ответить
@JoshKennedy-f8n
@JoshKennedy-f8n - 09.11.2024 16:26

This would have been incredibly useful, however, unfortunately, the feature is deprecated. It won't be around forever, which is not something I can afford to use. I'll have to find a different flow to do this

Ответить
@maverick_anoop
@maverick_anoop - 11.11.2024 22:32

Is there any way we can add voting button functionally in these emails?

Ответить
@jasonspratt5424
@jasonspratt5424 - 13.11.2024 23:08

Hi Jamie as part or my role i have to look for and follow up with employers reference insurance. what i was wondering was if ipower Automate could assist me and save me the time in contacting these employers requesting new insurance? Could power Automate link in with my spread sheet and send an email from my spreadsheet on the date that insurance expires requesting an employer to supply me with new insurance documents and have the same email repeat weekly until the new insurance documents are supplied please advise

Ответить
@stanleywong2452
@stanleywong2452 - 14.11.2024 09:31

Hi Teacher, do you have any idea if can we receive email on the Due date in Singapore date and time format?

Ответить
@markhemingway3393
@markhemingway3393 - 19.11.2024 20:53

Deprecated as a feature - no longer active

Ответить
@rafi2023
@rafi2023 - 19.11.2024 22:08

How can I add a formatted signature to each email I send, such as including a website with a URL link? Additionally, if I have 800 contacts, is it advisable to send them all at once, or might this cause the emails to be marked as spam?

Ответить
@ledrman
@ledrman - 20.11.2024 05:43

The template 'For a selected row, complete a custom action' is now deprecated. Do you have another option for this flow?

Ответить
@martinargimon730
@martinargimon730 - 23.11.2024 13:42

HI jamie. thx Very useful tip. Although I have a large table with many accounts so I usually would like to filter all the "pending" payments and hence there are lots of 'hidden rows". Will I be able to select ( highlight) the entire selection in one step with my cursor and then do you think excel will 'skip' all the hidden rows , and NOT add those to the email 'batch". hope my explanation is clear ? . thanking u in advance. Kind REgards martin ( south africa)

Ответить
@sonygoup
@sonygoup - 25.11.2024 17:38

Email formatted doesnt appear for me. Also it give error because it can see the email address

Ответить