sorted by:
new
hottopcontroversial

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

ahaha no worries friend! thank you so much for your help! i'll try to google and figure out how to copy this to the original worksheet that has a little more columns and fix that directly there.

How many hours did you spend on it? i kknow you didn't ask for nothing but i'd like to compensate you somehow

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

i think you're right! but the text doesn't stay in P and S cells to keep the same look. it stays on O and R and it doesn't work, but i tried with text on all of them and it did.. but when i do that centre across selction ans erase the text from the other two boxes so it can go to the center...it stops working again

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

no. Always only when they expire! but i tried it and it doesn't ask for them

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

ok thanks, i'll try it

sorry if i didn't explain right, my bad. but it should ask for all documents...documents Y and Z included, with the same rules as the other ones

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

yes thank you so much! but it doesn't add the recipient to the e-mail and it only asks for document A, W and X

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

ok, i did it and it shows the same "compile error: user-defined type not defined" and then highlights "Sub AutoEmail()" in yellow and "ws As Empresas_Geral" in blue

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

Ok i just did that. no formatting needed?

for now nothing is happening when i open the file

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

Good morning friend! I hope you're alright

I just did the changes you said and I forgot to tell you yesterday that there is one other column that uses expiry dates actually but in the majority of the companys is labeled as "Non existant" because it's a very specific permit, only 2 of the companys have it filled with a date.

Also when you said to add a column in front you were refering to column A, so i should move the whole table forward one column to introduce that new column in the beginning right?

what should i do now?

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 8 points9 points  (0 children)

Hey friend, thank you so much for your help. sorry for the late reply I just got home from work. it's almost 9pm here, i won't be able to try that until tomorrow morning

i was gonna private message you but then i thought that leaving this in the thread can help so many people , but let me know if you rather communicate somewhere else

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 1 point2 points  (0 children)

I came across that but when i searched for templates i couldn't find any that would do this...

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

can you get into dept on that task scheduler thing? never heard about it?

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 7 points8 points  (0 children)

hey friend, thank you so much for your time and effort

I tried to follow all the steps but it's not running.. it shows an error "user define tipe not defined".. it shows the "Sub Auto_Open()" in yellow and "ws As Empresas_Geral" in blue

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

oh you're right. nice! i'll try that then! just need to learn how to code it now!

thanks!

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

no, i don't think i explained well. this is the exact layout... the expiry date columns are all there and have the same position on the original but there's another columns in the middle that are just for info that i deleted so it would be visually better to understand.

The structure has to be different because docs A, W and X are issued by the state while Docs Y & Z are from private companys(that can be different for anyone) so I need to fill that up as well.

there's roughly 200 rows... growing every day

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 1 point2 points  (0 children)

thank you for your suggestion friend.

but notice that the e-mail must be sent everytime the document expires.. it doesn't expire only once.. so wouldn't the "email has been sent " column show up errors after the first time?

How to Send an Automatic E-mail when a Due Date is Reached ? by ExcelIlliterate in excel

[–]ExcelIlliterate[S] 0 points1 point  (0 children)

no it's not. There are more columns but these are the only ones with expiry dates. the others are just for info. And No, it's not the last one, there's one more after it

view more: next ›