Have a code that does this but never sure if it's sent without going to outlook.Is there a way to have message box popup in excel that mail was sent in outlook.Sometime it seems like stuff get hung up in the outbox,so if it not sent a error message.Not sure any of this is possible,maybe some links to examples would be helpful.I can post what I'm using now if needed.
Thanks for any suggestions.
Last edited by zplugger; 08-27-2015 at 07:57 AM.
Hi zplugger,
I've been trying to find a solution for you on this, but have come up empty handed. Couldn't even find anything on Ron de Bruin's website about sending a notification for sent, or not sent emails. May I suggest changing the .send to .display until a solution is found? This will allow you to preview the email first and then send it. I know this kind of defeats the purpose for auto sending emails, but, it might be a temporary or "band aid" fix for now.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Hey berlan,
Thanks for the rep on this.
Thanks gmrevr1 for trying to find solution to this.Just seems like 2 office programs could talk back and forth to each other.Did try the display idea,after I push send the program closes.Have
to open and make sure it not in outbox,wish I could have a cell on invoice to show sent or error in sending. Guess there is no good clear way to make this automatic.I will keep searching to a better mouse trap LOL.
Z
Do you mean outlook closes when you hit send? If so, what is the code that makes it close, maybe remove or comment it out? I use VBA to auto send emails through outlook and my outlook doesn't close until I close it.
Thanks again gmr4evr1 for the help,I need to find another example of sending email in excel.Need to see how another code runs this process,just need easy way
to tell if sent.There has to be a better way then what I use.
Z
Z,
Check out this link, it might be what you are looking for
http://stackoverflow.com/questions/2...-sent-manually
I did check it out, very lost on this. Would all this code go in excel workbook?
Please Login or Register to view this content.
would this part be adapted into my mail code now?
Looks like this is what I need if I can make it workPlease Login or Register to view this content.
Z
I'm afraid that this has gotten to where it is over my head now and I would have to play around with it a bit.. This is the only code I have found that seems like it would alert you when the email has been sent. I haven't been able to try it out yet to see how it works.
I know what you mean,will play around and see if I can make it work.Maybe we can get more help on this.
Thanks z
I found a link regarding checking if someone had press the send (below)
do you know why the messages get caught up in your outbox?
http://www.mrexcel.com/forum/excel-q...ml#post1605556
does send recieve all force them to go?
eg.
Please Login or Register to view this content.
Last edited by scottiex; 08-18-2015 at 11:03 PM.
This may not be exactly what you are looking for, but I also do a :BCC to myself on emails that automatically send via outlook. This way I see the pop-up in the bottom right corner when the mail is sent.
Thanks for the ideas guys, still searching for a good method to tell if email was sent.I like the idea gmr4evr1 had but cant make it work. Not sure how to set it up and where the code goes.Not
sure if anyone ever tried that code and got it to work?
Z
Wouldn't it be Outlook that tells you it was sent, how would excel know it was sent?
Possibly BCC it to yourself, then you would get a copy of the e-mail.
Edit: I see somebody else had the same idea.
Last edited by davesexcel; 08-21-2015 at 06:45 AM.
Thanks davesexcel for the input,so I should find a something in outlook to send data to active excel sheet if possible?.Gmr4evr1 had nice code but not sure if it works.
Z
if the PostOut folder is empty all mails have been sent:
Please Login or Register to view this content.
Thanks snb for the suggestion,little slow here so please bear with me.Where would the code you posted go? and what would it do?
Thanks z
for reading:
http://www.snb-vba.eu/VBA_Outlook_external_en.html
Thanks for the link snb, went to site and I'm totally lost. Think I getting in way over my head on this request, was hoping for a simple solution. After reading the suggestion from GMR4EVR1 was
thinking this would be easy.Done a lot of searching on this with no luck,maybe what I'm looking for is not possible.
Z
Hi zplugger
Post an image of what a typical Email looks like (jpg...NOT png). It seems to me we can query the Outlook Sent Folder to see if the Email we're looking for is in there.
If it's there a field could be populated with "Confirmed" or such. I don't know what time this would take in terms of the execution of the Code.
This is all "noodling"...just thoughts off the top of my head...may work...may not.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks for the suggestion jaslake,I change my code so when excel sents the email it will open outlook and I can watch the outbox then close after it sends.This seems like the best way to
see if it was sent. GMR4EVR1 code posted in early thread was what I was looking for but just seems impossible to get working.
Z
Howdy Z,
I'm still planning on trying out that code myself to see how it works, but haven't had a chance to yet.
Thanks, hope you have better luck them me. Problem having now is when I send email outlooks opens behind workbook,trying to get it to open on top of workbook when I send mail.
Try using this, or modify to your code to bring outlook to the top..
Please Login or Register to view this content.
Last edited by gmr4evr1; 08-22-2015 at 11:44 AM. Reason: Added info
Here is what I have now,could not make other code work?
Please Login or Register to view this content.
Comment out or delete this line
It is telling it to minimize outlookPlease Login or Register to view this content.
Or, comment out or delete the above and this line
and replace it withPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by gmr4evr1; 08-22-2015 at 12:18 PM. Reason: added additional suggestion
getting runtime 91 error
Please Login or Register to view this content.
Funny I can go to vba and change code and it works,save the workbook and reopen and outlook go to the back again?
If I take the vba project password off all works after save?
So, you want outlook to the front when you open the excel workbook then you have to place the code in the workbook section, below is the code..
Question, what is the Unload Me line for?Please Login or Register to view this content.
Good question, not sure why I had unload me.What I have is this code on a userform commandbutton to send email.So the button opens outlook and runs the rest of code. Send twoday package is the code for getting right email address and attaching a pdf to email. Any ideas whe the vba password would cause outlook not to open on top of the workbook when button is pushed?. Code works perfect if no vba password is set,set a password and it does not work right?
Here is a sample of the problem, password is 1234. if no password outlook opens on top,if password outlook open behind workbook?
Last edited by zplugger; 08-22-2015 at 01:34 PM.
Do you mean the password to open the VBA project window? Because with or without the password, I tried the sample you attached, clicked the button, and outlook opened and stayed on top of all other windows until I minimized or closed it.
I'm starting to think its not something with this code that is causing the problem, it's code somewhere else in the workbook.
yes vba project window,set password close and save workbook then reopen
Last edited by zplugger; 08-22-2015 at 02:12 PM.
Hmmm....I'm not having the same problem. I tried the way in my previous post, then just now I changed the password completely, saved the workbook, reopened it, clicked the button, and all worked just fine. Outlook stayed on top of all other windows until I minimized or closed it.
Does it happen to you when you try running the last sample attachment you posted?
Do you have a .Activate line somewhere else in your code? Other then the code in your sample workbook.
Last edited by gmr4evr1; 08-22-2015 at 02:44 PM. Reason: Added another question...or 2
No, having the problem with the sample workbook.Must be something in my excel program after saving? Not sure what to do now.
Yea, I think I'm at a loss on this one myself.
OMG this can make a old man cry,driving me nuts.Even tried the file on wife's computer and same problem,vbaproject password set and it opens behind workbook.Wonder if a reference is not set right? running office 2013 on my computer and she has office 2007. This is a simple code but can't get handle on problem. I can open the file 50 times with no project password set and runs perfect,add project password and it will not work right. Maybe someone has some more suggestions on this before I have no hair left.
Thanks z
Last edited by zplugger; 08-22-2015 at 03:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks