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
<A12> <C12> <F12>
<A37> <C37> <F37>
"
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.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
<A12> <C12> <F12>
<A37> <C37> <F37>
"
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?