HI guys,
I am new to this,
I have a file that need to be check if the dates are due, and i need to send a e-mail to the person whos date is almost due, each person should have up to 20 documents attach,if one or more are due an e-mail should be sent.
the file looks like this
ID Name E-mail Doc1 Doc2 Doc3 Doc4 and so on, if one doc is due an email should be send to the person.
I am trying to use VBA to help me on it.
any helpwould be great.
thanks
Bookmarks