mail merge using data in excel
I want to create a batch of e-mails drawing on a data table in excel which is the output from a database, through outlook.
i.e. I want to create a message to send out to users of a database which has actions held in it to tell each user about their outstanding actions.
e.g.
everything in {} is a field relating to a column in excel
sent to {useremail}
"
Dear {user},
You have the following outstanding actions:
ID Action Title Due date
{CellA12} {CellE12} {CellG12} {CellR12}
{CellA37} {CellE37} {CellG37} {CellR37}
"
Where an individual (and only one) e-mail is sent to any user with an outstanding action and the e-mails are created in a batch ready to be sent (I don't mind clicking the send button a few times)
Any ideas?
I want to create a batch of e-mails drawing on a data table in excel which is the output from a database, through outlook.
i.e. I want to create a message to send out to users of a database which has actions held in it to tell each user about their outstanding actions.
e.g.
everything in {} is a field relating to a column in excel
sent to {useremail}
"
Dear {user},
You have the following outstanding actions:
ID Action Title Due date
{CellA12} {CellE12} {CellG12} {CellR12}
{CellA37} {CellE37} {CellG37} {CellR37}
"
Where an individual (and only one) e-mail is sent to any user with an outstanding action and the e-mails are created in a batch ready to be sent (I don't mind clicking the send button a few times)
Any ideas?