I have a Excel spreadsheet with around 500 names containing the name of the person and their email address etc. Apart from spending weeks, typing up an standard email, adding the specific names and emails from an excel spreadsheet, I have read this process can be automated using Outlook and Excel which would save me weeks.
I am using Office 365 and largely use the Web Client however can use the Outlook client on the PC if it makes it easier. All I want to do is,
1-Create the standard email
2-Save it as a template
3-Then get Outlook to run through the Excel spreadsheet, pick the 1st email in the row, then in the same row pick the name of the person and amend it in the body and send.
4-Repeat the same process for the second row, third row....for 500 people.
I have seen some add-ins to buy online however wasn't sure if they actually work or how robust they were hence wanted to find out from the experts what the best solution was which was easy. Microsoft pointed me to this forum.
13 freelancer đang chào giá trung bình $151 cho công việc này
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss. Regards. Stay tuned, I'm still working on this proposal.
**** I have read your task details carefully and understand about your need. Please be inform I have better experience on office 365 and outlook and also email automation. let's discuss if interested.
hi i am a data engineer. i have a code that does the same thing as you want. please feel free to contact [url removed, login to view] body don’t change?