Page 1
Page 1
Started By
Message

VBA Script for Outlook Help

Posted on 3/7/14 at 9:34 pm
Posted by Paedin
Tampa, Florida
Member since Apr 2012
2290 posts
Posted on 3/7/14 at 9:34 pm
Any OT computer ballers that can help me with the following solution?

I need to create a Macro button for Outlook to do the following:

Create a new message
Add a email to the To: field
Add a distribution group to the Bcc: field



I want to make it so that an employee can just click the button when doing group emails, so that I get a copy, and the distribution list each get individual copies.

Posted by au21tigers
Thursday
Member since Nov 2009
12548 posts
Posted on 3/7/14 at 9:37 pm to
<< @gmail.com

You have paypal?
Posted by Doldil
The Ham
Member since Jan 2010
6214 posts
Posted on 3/7/14 at 9:38 pm to
that's absurdly lazy if the Distribution group is already set up...it's like 4 button clicks to do all that...

That said, go to the developer tab and under macro's there should be an option for record macro. turn it on, add the proper people to the To and BCC field and then stop macro. Should be that simple I'd imagine, but I'm not in outlook or at work to actually test it to know if it works
Posted by au21tigers
Thursday
Member since Nov 2009
12548 posts
Posted on 3/7/14 at 9:39 pm to
Depends on what outlook he has
Posted by ell_13
Member since Apr 2013
85034 posts
Posted on 3/7/14 at 9:40 pm to
quote:

record macro. turn it on, open "new", add the proper people to the To and BCC field and then stop macro.
fify just to be safe and cover the bases. Should work.
Posted by Paedin
Tampa, Florida
Member since Apr 2012
2290 posts
Posted on 3/7/14 at 9:41 pm to
There is no record macro option in outlook that I can find. It has to be coded.
Posted by Doldil
The Ham
Member since Jan 2010
6214 posts
Posted on 3/7/14 at 9:42 pm to
What version of outlook are you running...the developer tab is hidden by default.
Posted by Paedin
Tampa, Florida
Member since Apr 2012
2290 posts
Posted on 3/7/14 at 9:44 pm to
2007 - and I already have the dev tab turned on. I can get into VBA editor to do the coding work. But been googling it over a hour and can't find a code to do what I want.

Trying to make it simple stupid for a person to do a 1click so that the distribution list goes to bcc so there is no way it gets sent out incorrectly.
Posted by Doldil
The Ham
Member since Jan 2010
6214 posts
Posted on 3/7/14 at 9:47 pm to
Posted by Paedin
Tampa, Florida
Member since Apr 2012
2290 posts
Posted on 3/7/14 at 9:56 pm to
Thanks doldil!

Works for what I need.

first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram