Enter your email address:

Delivered by FeedBurner

Home Page








Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  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.

". . . a new add-in named RDBMail for Excel/Outlook 2007-2010

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

Labels: , , ,

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

  Sunday, February 14, 2010 – Permalink –

Display Order

What’s on top

Outlook allows you to rearrange how information is displayed in your email list.

(Outlook 2010)

See all Topics

Labels: , ,

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

  Wednesday, October 14, 2009 – Permalink –

Access to E-mail

What's the Outlook?

Garry Robinson from GR-FX Pty Limited of Australia and Scott McManus from Skandus, have a tutorial about:

Processing E-Mail Orders using Outlook and Access.

They have include sample database downloads and the code needed to make the engine work.

"Using Microsoft Access and Outlook together can reduce manual processing of Ordering emails very substantially. I know this because sometimes it would take up to 15 minutes to undertake all the little steps of saving customer details into tables and newsletter lists. Also without software, it was very difficult to explain to other staff members what to do when an e-mail arrived. Now we can process the orders in a couple of minutes when Outlook email arrives in the correct folder."

See all Topics

Labels: , , ,

<Doug Klippert@ 3:03 AM

Comments: Post a Comment

  Friday, October 02, 2009 – Permalink –

Messy Email

Junky appearing addresses

Office-Watch is a great newsletter covering Email/Windows/Access and Office in general.
One of their recent offerings tackled email addresses:

Which of these email address (all fake) is formatted correctly?

"Frederick Dagg"






The answer is that they are all strictly valid though they might not be useable in practice.

Further discussion at:

See all Topics

Labels: ,

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

  Friday, August 21, 2009 – Permalink –

Search Folder Magic

Store searches

Messages are not stored in Search Folders. Search Folders are virtual folders that contain views of all e-mail items matching specific search criteria.

Search Folders display the results of previously defined search queries. The e-mail messages shown remain stored in one or more Outlook folders.

In Mail, in the Navigation Pane, there are three default Search Folders

  • For Follow Up,

    Any e-mail item with a flag appears in the For Follow Up Search Folder.

  • Large Mail,

    E-mail items that are larger than 100 kilobytes (KB) appear in the Large Mail Search Folder.
  • Unread Mail.
  • All unread e-mail items appear in the Unread Mail Search Folder.
Right click the Search folder icon to create a new Search folder.

When you create a Search Folder, you have a number of options to choose from, such as "Mail with attachments" or "Mail from specific people."

You can also create your own custom Search Folders, defining specific search criteria that e-mail messages must meet to be displayed in the Search Folder. Each Search Folder is a saved search that is kept up-to-date, monitoring all of your folders for any item that matches the search criteria of the Search Folder. When you delete a Search Folder, the e-mail messages shown in the Search Folder are not deleted, because those items are never saved, only viewed, in a Search Folder. However, if you open or select one or more e-mail messages shown in a Search Folder and delete the e-mail messages, the messages will be deleted from the Outlook folder where they are stored.
 Search Folders

Outlook's search folders retain the results and remain up-to-date by adding new messages to the search folder as they arrive, provided you view the contents at least once every 8 days. If you use the folder less often, Outlook will need to rerun the search. Because Outlook has a limit of 20 search folders, use Advanced Find for less used searches. When you save the Advanced Find search, it's almost as fast and convenient as Search Folders. Advanced Find allows you to save the searches as Office Saved Searches (*.oss). Choose File, Save Search.

Once saved to your hard drive, you can copy them to any folder within Outlook, or drop it on the Outlook bar for easy access. To run the search, just double click on it.


See all Topics

Labels: , ,

<Doug Klippert@ 3:10 AM

Comments: Post a Comment