Hi, I am looking to automate a daily process to pull in contacts from a CSV (that sits at a fixed URL - or could be imported into google drive if easier?) and then send out an email to them. The CSV will hold only the previous day's new contacts so there would be no need to remove contacts that have already been emailed. We would only need the email address (no first name etc.) if that makes things easier.

Is it possible to automate this process and what do you think we would need (i.e. can we do it off-the-shelf or would we need to get s VBA expert to do some code for us)?

We are using office 365 for our mail and would love the process to all be cloud-based but I'm not sure if a cloud-based mail merge is even possible without automation?

Thanks for any help in advance!