Forum Discussion
Send Emails from Excel
Hi,
I need to send out emails for each product at the start of each month. I also send a follow up at BD7 if no response is received. I have my spreadsheet set up with the message to email, and rows for email address address to send to. This works like a mail merge, however i am attempting to get this to run via macro on the first business day each month, and after 7 if required.
I have seen a macro online, and have included but have had no luck updating to match my current criteria.
Can someone please assist.
Many thanks,
3 Replies
HI calof1
I feel the best way is to extract you data in excel via Power Query and the you can just make query as per you need.. I feel you should give a try with Power Query
Regards, Faraz Shaikh
ExcelExciting , how you may organised scheduled emails distribution with Power Query?
- For scheduling emails can be done with Power Automate..
