Automatic sort due date and send email

[DocAElstein]

Hello Thai,

one minor issue that the password for our share email is incorrect in the code. I will send you our share email password again……
here is our share gmail password.
xxxxxxxxxx....

Thanks very much for this information.
I see now that I made a mistake.
You are correct: I way using the wrong password. That explains why I had difficulty getting the code to work with excellearning12@gmail.com as Sender

I had mixed up passwords.
You are correct: This is the gmail share account that you made:

excellearning12@gmail.com
Exxxxxxxxxxxxxx

_-._________

( I also made an account for us with Outlook ( http://www.excelfox.com/forum/showth...0698#post10698 )

excellearning@outlook.de
Xyyyyyyyyyy

As you can see, I had mixed up the passwords. )

Thanks for pointing out my mistake.

_.__________________________________

I notice the code only copy and past the text from excel to email. I wonder if we can include like the picture below…….

I think it should be possible to meet all your requirements.
Just for example: this is the sort of Mail I receive everyday from my wife.
ExampleEMail.JPG : https://imgur.com/MN5a0Ny
ExampleEMail.jpg
I use a very similar code to that which we are developing.

So you see, all is possible, but will take me some time to do different formatting.

-.________________________________

…
_ (i) Can we include wording on the email body
and
_(ii) hyperlink such as " Your Tool/Equipment is up for Maintenance service, Please click on the file to open Equipment PM template." Open File here.
.

_ (i) Extra wording is easy. No problem
_(ii) I have not myself done a hyperlink as you want. But I am keen to learn how to do this as it will be useful to me also. I am sure this is also achievable



_.________________________________________________





I will post again when I have time, possibly in a few days.


Alan