Automatic sort due date and send email

[DocAElstein]

Hello Thai,
Thanks for the extra info, thanks and for emptying your InBox.
_.______________

So far, I didn't receive any of your email with the template. That is weird. ..

have you checked any Spam Folder you may have. ? Can you check if you have any company IT department to see if they block such Emails?

I used my German Telekom Email address to send to you.

I am just interested to see where the problem lies in case I have a problem with the Emails that I send generally from my German Telekom Email address: I am not aware of any problems. I am in constant contact with people using my Emails and was not aware of any problems with anything that I send not arriving.
So I am just curious..
Also, as we are using automation of Emails, it would be of interest to know if there are issues with any particular Email addresses with your company, as this may raise issues in the codes we are using
_.______________________________

Just out of interest I will re send the copies of the Emails I sent yesterday using my Telekom account, but this time using my gmail account.
I will send again to your company EMail
I will also send to out shared Email address**
Please tell me if you receive this information.

_.______________________________

**I will send as you have requested the File, “Equipment- Maint RecordsThai1.xlsm” once again, but this time I will send it on our shared address which you have registered for us, excellearning12@gmail.com

Finally I will also, just out of interest , send a copy of my Emails from yesterday from my Telekom address to our shared address which you have registered for us, excellearning12@gmail.com
_.__________________________

So I will send you three Emails, ****
_1 one on your company address, from my gmail account. This is just a copy of what I sent you yesterday.
_2 a new Email I will send with the file “Equipment- Maint RecordsThai1.xlsm” attatched using my Telekom account and sent on our shared gmail account, excellearning12@gmail.com
_3 Finally one on our shared address, from my Telekom account. This is just a copy of what I sent you yesterday

Please tell me what Emails you receive from those 3 which I send. I will send all three shortly after I post this Forum post which I am writing now
_.__________________________

...I am using my template on my desk top with your VBA code and it is working. It sent notification through our gmail...

.. so… It would appear that you have already managed to get a code version to work which is similar to that in the file from me, “Equipment- Maint RecordsThai1.xlsm”
But just to be sure, I suggest you check the file that I have sent ( will re send ) ; and follow my instructions from http://www.excelfox.com/forum/showth...0675#post10675 ; and make sure you understand what is going on
_.______________________

... Now how can i turn it to a good template and send notification through my outlook email?..

As I mentioned to you, I do not have Outlook. I have no experience using Outlook VBA code. But I did give you some information regarding the "smtpserver" issue per PM.
_.______________

... Also, can you help create Subject and Body on the email with hyperlink to the template. Example. .....

I suggest we take things one step at a time.

_1 Tell me what Emails you receive from the 3 which I will send to you in a short time after completing this Forum Post.
_2 Check my file, ( if you receive it ). Follow my instructions from http://www.excelfox.com/forum/showth...0675#post10675 and make sure you understand what is going on. – You may have already done something similar to this. But I am not sure exactly what code you used for your reported…”…..I am using my template on my desk top with your VBA code and it is working. It sent notification through our gmail….”…….
_3 We will address the issue …”…. Now how can i …… send notification through my outlook email?..”.. Hopefully this will just be an issue of getting the correct "smtpserver" But I am not sure.

_4 the other issues we will then look at later

I will take another look in over the next few days.
I suggest you review again all my posts and PM’s ( I suggest you make text or Word copies of PM’s, as , as you have experienced , the storage of them is limited at excelfox. We should also keep as much information as possible in this Forum Thread , for the benefit of others who may be following the Thread now or in the future. )




Some last points. These are just suggestions:
_A) . You might want to consider using a separate Email account , as we are doing here with the excellearning12@gmail.com for this project. I do this and have found it very convenient. This way I always have a separate source of copies of all sent Emails via my code, and I do not clutter my main Email accounts with this extra information. Such an account you could also share with your colleagues and team members. So they would also have a record of all
_B) It is very easy to arrange that the sent Email has an attachment such as an Excel File. Currently we are not using that option. The code could easily be modified to send attached a complete copy of the file, which can also be arrange to not include or to include the coding.




Alan

P.s. Please do not delete anything from our shared account, excellearning12@gmail.com , so that we can keep track of all infomation between us as well as all of our experiments



****EDIT: All 3 EMails were sucessfuly sent by me

[Thainguyen]

Hi Alan,
Thank you for all your hard work. I got your all your email and template now. It is working out great. Also, it did sent email to my work email when i am using the run sub/user form function. However, when i am open and close the template, it only send email to my gmail only.

Now I believe we can remove the testing code and working on the rest of the code to identify due date from column G, I, K to send an notification to me and my team.