Hi Thai,
Yesterday I got sent to me Emails, presumably from the code that you were experimenting with.
It appears to me that you are making good progress. You seem to have the code working to some extent. Good

_.________________________________________________



Unfortunately, I do not quite understand what you are saying here:
Quote Originally Posted by Thainguyen View Post
… 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. .
I do not understand exactly what you are trying to say.
Because I do not understand this, I do not quite know at what stage you / we are.

I can see that you have successfully used the code to send Emails. I think you have done this using our shared Email account, excellearning12@gmail.com as the sender, using our code, Private Sub Workbook_Open().

I do not know if you have successfully used your company Email ( Outlook ) as the sender using our code, Private Sub Workbook_Open(). ??
Have you used your company Email ( Outlook ) as the sender using our code, Private Sub Workbook_Open(). ??
Is your plan still to use your company Email ( Outlook ) as the sender using our code, Private Sub Workbook_Open(). ??
If your answer to the above questions is Yes, then please tell me which "smtpserver" you used to enable our code to send from your company Outlook address. I would be interested to know that. ( As I mentioned previously, I have only used such codes to send from
either
Google Mail, gmail.com
or
German Telekom, t-online.de, Email accounts )


I would suggest that at this stage, that you do not try to get the code to work automatically when the Workbook is opened.
It easier to test the code working manually. It is very easy later to just transfer the code over to the ThisWorkbook code module.
But , It is easier to develop and test the code manually at this stage.

_.______________________-


I have reposted your given Outlook VBA code using code tags Here:
http://www.excelfox.com/forum/showth...0690#post10690

Code tags makes it easier to see in the Thread.


I will examine that code over the next few days. I think I understand your further requirements ….”….. create Subject and Body on the email with hyperlink to the template….” Etc..
I will look into this.



_.____________________

I will happily help you further, when I have time.
But I need some clarity as to what stage you are currently at.
I was not able to fully understand your last post ( http://www.excelfox.com/forum/showth...0688#post10688 )




Alan