VBA to email on upcoming expiring dates

Good Morning,

I was wondering if someone can help me out with this? I have a list of suppliers we would like to send emails out to when the expiring dates are coming up. I would like it to be similar to this. get.sysdate -21. Basically take today's date and kick off email that is set to expire 21 days. Email program of choice is Office 2013 Professional. Can someone please help me???

Hi!

I did a plan this way...

See if helps you..

If you need help to translate, talk to me ..

Good Morning Rssmith93,

How can I edit the .xls and translate it to english? Again ty for the help much Appreciated

oh, sry ..
press BD and put the password 250914...

VBA password is Isa250914

Im sorry for bugging you but how do I get into the VBA portion to edit it?

Press alt + f11, it will open the VBA editor...use frmCadastro to edit the most part of the sheet

I can't get the email button to work. I am getting the following error "Run-time error '-2147417851 (80010105)' " Im using office 2016

I guess you must change the VBA Code that executes the email aplication..

I'm newbie, and I dont know how to fix this..sorry!

Maybe others users could help you...

Does it executes for you?

Yes, here its works perfectly...

but I'm using Office 2013 and Outlook 2013...maybe you can change the configs of the email in VBA, i guess it will solve your problem..

Look in the web for sending emails by VBA...you'll find something..

ohh

try this...
ON Vba Editor, go to TOOLS > REFERENCES and add Microsoft Outlook...

One last question I promise. Where are you pulling this from?

Prezado(a) 5,
A tarefa 3 da empresa Rose Shore com data limite 4 está Pendente.
Tarefa Código: 5
Verifique com urgência!
Atenciosamente,
Controle de Tarefas

Please Login or Register  to view this content.

From macro called EnviarEmail..its in formCadastro... just change the texts u want..

Found it? The sheet is working now?

You can do how many questions you want, I'll try to help you...i just don't do more 'cause i'm not so good in VBA either in English =P..but i'll try to help, always...

Ok ty for your help on your VBA main menu you have status with a drop down box. it is set to "Pendente" how can I change that to Pending? Where can I modify that?

On VBA project press CTRL + L then substitute every "PENDENTE" on the actual project for the word you want.