automatic sending mail from excel 30 days before due date

**tekken** · 08-13-2013, 08:42 AM

Hey

is there anyone who can help me with vba code for Automatically sending email with outlook when cell N3 to N2000 in sheet3 is 30 days to due date.

for example if N5 is 30 days dueDate will get a mail automatically where cell D5, E5, G5, H5, J5.K5, L5, N5 is copied and sent in the mail,
and the same for N6 where D6, E6, G6, H6, J6.K6, L6, N6 copied and so on.

**codeslizer** · 08-13-2013, 09:30 AM

Hi Tekken,

Yes, we can help. Will you be able to provide your sample work file removing all your sensitive data. This is to avoid re-working on requests as we try to clear doubts and confusions in minimum posts.

**RichTea88** · 08-13-2013, 11:23 AM

Good Afternoon Tekken,

Please see the below code. I've ripped it from my own code and editted a wee bit. I've left a few lines of my code in, for example in the message for the e-mail, so you can see how reference certain cells. This code checks column 'O' to see if an e-mail has already been sent and if not then checks row N for the date. If it's within the next 30 days it will generate an e-mail, it doesn't send automatically. Then puts an 'X' in column O, so when you open the workbook again it won't generate an e-mail everytime. you can change this easily though. It repeats this until every row is checked. beware, if you have 100 e-mails to be sent in the next month and apply this then it's going to generate 100 e-mails, which can take a while, and can be a pain in the *** to close :P

Hope this helps, if not reply with a sample workbook as advised by Codeslizer

Please Login or Register  to view this content.

**tekken** · 08-14-2013, 09:12 AM

hey

do you have the opportunity to take a look at it, I copied the code you made but it was not working the way i would have it, the sheets do not start before row 3 and is it possibility to copy colum D, E, G, H, J.K, L, N in the mail?