Unofficial Outlook Stuff

Book

Suggestions

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Wednesday, March 03, 2010 – Permalink –

Mail Excel

VBA + sample
Excel Guru Ron de Bruin has put together the VBA code needed to send Excel via email.
He has also included the sample workbooks for those that are not VBA literate.

Also:

". . . a new add-in named RDBMail for Excel/Outlook 2007-2010
http://www.rondebruin.nl/mail/add-in.htm

The add-in create a new tab on the Ribbon named RDBMail with a lot of mail options.
You have the option to send as workbook or PDF for every mail option."

Code to send mail from Excel

See all Topics

outlook
Labels: Email, Macros, Tips, VBA

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Friday, January 29, 2010 – Permalink –

Stop Reply To All

Macro magic
Scott Hanselman (who is ". . . an old fat guy with a Black Belt that used to fit") has a tutorial on how to disable "Reply to All".

How To Easily Disable Reply To All And Forward In Outlook

See all Topics

outlook
Labels: General, Macros, Tips

<Doug Klippert@ 3:03 AM

Comments: Post a Comment

Thursday, April 09, 2009 – Permalink –

Excel-lent E-Mail

Outlook, Excel, and VBA

Ron de Bruin, Microsoft MVP - Excel, has put together a collection of VBA routines to make Excel e-mail friendly.

See if these topics tempt you:

Example Code for sending mail from Excel

Mail Workbook

Mail one Sheet

Mail more than one Sheet

Mail the Selection or range

Mail Every Worksheet with Address in cell A1

Mail sheet or sheets to one or more people

Mail range or sheet in the body of the mail (Send personalized email)

Mail a message to each person in a range with Outlook

Mail a message to each person in a range with CDO (no security warnings)

Sending a different file to each person in a range with Outlook

Zip the ActiveWorkbook and mail it with Outlook

Security (Prevent displaying the dialog to Send or not Send)

Also Download Addins for Excel e-mail information
Also see:

John Walkenbach:
Sending Personalized Email from Excel

See all Topics

outlook
Labels: Addins, Macros, Tips, Tutorials, VBA

<Doug Klippert@ 3:28 AM

Comments: Post a Comment

Thursday, June 19, 2008 – Permalink –

Global Area Code Changer

Fix Contacts

Telephone area codes sometimes run out of numbers and need to be split. Slipstick.com's Outlook Contacts Tools page offers some suggestions including:

Slovak Technical Services:
Phone Changer

After a reorganization or buyout, have you ever needed to replace domain portion of e-mail addresses in a Contacts folder?

Here's a macro from Woody Leonard's WOPR forum.

Global Change of email addresses
(If you use it, you might want to comment out some of the MSGBOX entries. )

See all Topics

outlook
Labels: Contacts, Macros, VBA

<Doug Klippert@ 4:53 AM

Comments: Post a Comment

Saturday, March 31, 2007 – Permalink –

Comment Code

Edit toolbar

You'll many times want to change blocks of code to comments in VBA modules; temporarily convert a block of VBA code to comments so that it's ignored during a trial run. Inserting an apostrophe before each line of code is a bother. Office 2000+ simplifies this task by letting you convert a block of code to comments with a click of a button.

Open any module in the Visual Basic Editor (VBE), and then choose View>Toolbars and choose Edit from the menu bar to display the Edit toolbar.

Select the lines of code that you want to turn into comments. Then, click the Comment Block button on the Edit toolbar (it's the sixth button in from the RIGHT end of the toolbar).
Each line of the selected code is now preceded with an apostrophe.

To convert the comments back to executable code, select the appropriate lines and click the Uncomment Block button, which is immediately to the right of the Comment Block button.
This, of course, works in any application that uses the VBE.

Ross, suggested that two or three apostrophes (sometimes called inverted commas) be placed around existing comments. When the Comment Block is used, the original comments will not be removed.

See all Topics

outlook
Labels: Macros, VBA

<Doug Klippert@ 7:07 AM

Comments: Post a Comment