Printable View
I will mention the file path in the code and i will mention the file name
there can be 1 file or 100 file that i have to mail so i will add the file path and file name in the vba code
all files which i have to mail is excel file only
all this i have to by vba only
Let us assume sir email id abc@gmail.com
Plz have a look Sir and do needful
Any question plz ask
Hello Avinash
Please do this:
Register a new temporary spare gmail account, ( https://accounts.google.com/signup/v...owEntry=SignUp
https://www.lifewire.com/how-to-crea...ccount-1171924 )
( Use any name , Username and any Password).
Then contact me by PM message, ( http://www.excelfox.com/forum/privat...o=newpm&u=9041
)
Give me the Username and Password of the temporary gmail.
I will then tomorrow try to write a VBA macro using this temporary gmail address.
If it works, you can then change the gmail to a real gmail address and disregard the temporary one.
Alan
P.s. see also these Threads:
http://www.eileenslounge.com/viewtop...228710#p228710
http://www.excelfox.com/forum/showth...and-send-email
http://www.excelfox.com/forum/showth...kbooks-at-once
Email Id and paasword sent via Pm
Hi,
The gmail account is working normally. Thankyou
I will post again here in this Thread when I have more infomation for you
Alan
Hi,
I am still working on a macro for you.
But here is some important information
You may see similar to this:
gmailInBoxWarnings 1.jpg : https://imgur.com/oHgYfQB
gmailInBoxWarnig.JPG : https://imgur.com/ltyKMEu
EMail Warning : https://imgur.com/INiwLck
SignInAttempt.jpg : https://imgur.com/uTUtoUw https://imgur.com/XXJDEPK
You should check activity:
gmailInBoxActivityCheck.JPG : https://imgur.com/55ISCRe , https://imgur.com/JjwSoMT , https://imgur.com/RWvmaox
Please, always say Yes
gmail SayYes.JPG : https://imgur.com/AkxX5Mv , https://imgur.com/8T7oCfO , https://imgur.com/ZweyRnl
Also if you see this, always say OK : https://imgur.com/uAzn93s https://imgur.com/IMSh6Mo
You may also need to do this:
LessSafeApps Unblock.JPG :
https://imgur.com/sLQgC9C
https://imgur.com/DKnLSdl
https://imgur.com/pOSwrlr
Check Settings
https://www.youtube.com/watch?v=AFRqT3BR_e0
___Privacy.JPG : https://imgur.com/w6gX4Su , https://imgur.com/tER8rK9
___Google Account.JPG : https://imgur.com/R7lt25N ( or Go to Google Account.JPG : https://imgur.com/JP2jzuH )
Or _Go to Google Account: https://imgur.com/7MotjGI
Security.JPG : https://imgur.com/2kB3RpK , https://imgur.com/icuOfKE
Less Secure Apps On.JPG : https://imgur.com/qHFAd13
Always allow Less Safe Apps for the temporary gmail.
https://imgur.com/UykgYC8 , https://imgur.com/7RdR8hd , https://imgur.com/CryDH1d , You may then see this: https://imgur.com/bstPryz , so check activity https://imgur.com/Vr2Qjub , and say yes https://imgur.com/hDMdmX0
Always say Yes.
Always agree to it.
Always check that _ Less secure app access _ is _ On
If at any time you are asked about anything to do with the temporary gmail, mail2taste@gmail.com , then always say Yes, always agree .... ( but ignore these warnings EMail warning to Turn Off Less Secure Apps.jpg https://imgur.com/ZaLkUh0 Do Not turn Less Secure Apps Off)
I will post again , here, some time in the future.
Alan
Hi,
I am having difficulty getting the gmail account which you gave me to work with a macro to send EMails.
On further investigation, I am also finding that some of my gmail accounts do not work in a macro to send Emails and some of my accounts do work with a macro to send EMails.
So this problem is also interesting to me. I shall investigate further in the next few days when I have time.
I have also asked for help here:
https://stackoverflow.com/questions/...-be-sent-to-sm
https://stackoverflow.com/questions/58286932/cdo-gmail-macro-some-accounts-work-some-don-t-message-could-not-be-sent-to-sm
https://telekomhilft.telekom.de/t5/E...4219080#M72050
https://telekomhilft.telekom.de/t5/E-Mail-Programme/Die-Nachricht-wurde-nicht-an-den-SMTP-Server-gesendet-werden-Der/m-p/4219080#M72050
If you have any other spare gmail accounts, then I can try them. Pass me the Password and Username per PM
If we cannot get over this problem, then I can work further on a full solution using one of my Email accounts.
Further, if we cannot get an account which you have registered to work, then I can possibly give you the Password and Username per PM of one of my spare Email accounts.
I will review the situation in a few days.
Alan
No Problem Sir u tried and u give ur best that is enough for me
Thnx alot for giving ur Great Support Sir
I really Appreciate Ur hard Work for this post Sir
Hello Avinash,
Just out of passing interest… I have solved my problem with my CDO Send Mail coding. I posted a series of demonstration macros, with explanations.
( https://stackoverflow.com/questions/...95299#59695299
https://stackoverflow.com/questions/...79705_59756971
http://www.excelfox.com/forum/showth...ll=1#post11548
)
I have posted you a version adapted to your Email addresses. It contains some real Email addresses of yours and mine so I have posted it to you via a private message. Please be careful with the file. Do not share it openly.
Alan