outlook vba?
- Thread starter dan_l
- Start date
Aurelie
Member
You could start here: http://chandoo.org/wp/2012/04/23/send-mails-using-excel-vba-and-outlook/
Or are you looking for VBA solutions for outlook only?
Good luck!
Or are you looking for VBA solutions for outlook only?
Good luck!
SirJB7
Excel Rōnin
Hi, dan_l!
Agreeing with Aurelie theory now a bit of practice:
http://chandoo.org/forum/threads/ma...ments-to-an-email-in-outlook.8350/#post-48132
http://chandoo.org/forum/threads/row-merging-based-column-values.9936/#post-56814
Just advise if any issue.
Regards!
Agreeing with Aurelie theory now a bit of practice:
http://chandoo.org/forum/threads/ma...ments-to-an-email-in-outlook.8350/#post-48132
http://chandoo.org/forum/threads/row-merging-based-column-values.9936/#post-56814
Just advise if any issue.
Regards!
dan_l
Active Member
No no. I can do all sorts of emailing from Excel. I'm trying to do do some straight outlook stuff. So I ganked this code:
http://forum.groovypost.com/microsoft-office/conditional-auto-bcc-vba-t96912.html
But I'd like to make it run conditionally based on the sender email address. And....I can't figure out where the sender's email address is stored.
http://forum.groovypost.com/microsoft-office/conditional-auto-bcc-vba-t96912.html
But I'd like to make it run conditionally based on the sender email address. And....I can't figure out where the sender's email address is stored.
SirJB7
Excel Rōnin
Hi, dan_l!
If it's not about a matter of job for yesterday, in my old notebook I have done a few things with VBA in Outlook, it was for the 2007 version. Mostly was analyzing From, To, certain keywords in Subject, and copying them so as to don't get the original marked as read (it wasn't my idea!, I only did the dirty job).
But in fact I remember that it was a hard and tedious work since Outlook doesn't expose its VBA object reference as Excel or Word do (PowerPoint neither does), my most hated enemy was identifying which account (ergo folder) was the mail incoming into, I spent days with that.
Without any expressed nor implied warranty I'll try to find -1st my old notebook, then if there's still something alive there- out this code and if I do I'll post it here.
Regards!
PS: I do have to find three or four other things that I had there, operations with large numbers (hundreds or thousands of digits), prime numbers stuff, ...
If it's not about a matter of job for yesterday, in my old notebook I have done a few things with VBA in Outlook, it was for the 2007 version. Mostly was analyzing From, To, certain keywords in Subject, and copying them so as to don't get the original marked as read (it wasn't my idea!, I only did the dirty job).
But in fact I remember that it was a hard and tedious work since Outlook doesn't expose its VBA object reference as Excel or Word do (PowerPoint neither does), my most hated enemy was identifying which account (ergo folder) was the mail incoming into, I spent days with that.
Without any expressed nor implied warranty I'll try to find -1st my old notebook, then if there's still something alive there- out this code and if I do I'll post it here.
Regards!
PS: I do have to find three or four other things that I had there, operations with large numbers (hundreds or thousands of digits), prime numbers stuff, ...