VBA + sample

". . . 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."

Labels: Email, Macros, Tips, VBA

Steps to try

Labels: General, Troubleshoot

Access additions

Labels: Customize

What’s on top

Labels: Email, General, Tips

Context Menu

Labels: Tips, Tutorials, VBA

2003-2007-2010

Labels: General, Ribbon

Suggestions

• LINKS TO TIP SHEETS AND ARTICLES
  

  "Instead of telling your users to go out to Microsoft.com and do a search, put hyperlinks to the printer-friendly version of tip sheets and articles on your company’s main portal page. Providing links to information you know they need will help you cover the training bases. And presenting the links on an internal web site they already use will show your users that it’s okay to go outside of their four firewalls to learn something new. Include your favorite hyperlink in your signature line so it goes out in every e-mail you send."

• ONLINE TRAINING
• E-LEARNING
• WEBCASTS
• VIRTUAL TRAINING
• MULTILINGUAL SCREENTIPS AND TRANSLATIONS
• COMMAND REFERENCE GUIDES
• OFFICE ONLINE AT WORK

Labels: Tutorials

Macro magic

Labels: General, Macros, Tips

Suggestions

Labels: Tips

Do it your way

. . . you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between. You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like. Use different color schemes, and show more or less detail in your calendar.

Labels: Calendar, Tips

Sign it your way

"Signatures can be created in different formats and it can contain various elements. A basic signature will have just the sender's name. Along with the name you can include acknowledgments like "Thank you", "Yours Lovingly", etc. Official or business signatures will have company name, contact number, company address, website URL, etc. Company logo or any other relevant graphic can also be used. Any text in the signature can be hyperlinked. Sometimes electronic business card or scanned signature is also used. The text of the signature can be formatted to make it more attractive. Occasionally signature will also contain disclaimer blocks like stating, "If you are not the intended recipient of the e-mail then you should delete the e-mail".

Labels: Signature

Finger it out

After completing this course you will be able to:
Accomplish tasks by using sequential shortcut keys, known as Key Tips, shown on the Ribbon.
Navigate around the Ribbon using the TAB key and arrow keys.
Accomplish tasks by using key combinations — keys you press at the same time - exactly as you've done in previous versions of Office.

Labels: Shortcuts, Tips

Instructions

Labels: PST, Tips

Set your own

" Email is a quick, cheap and easy means of communication. This makes email a great business tool, but at the same time a potential threat for employers. Email threats such as confidentiality breaches, legal liability, lost productivity and damage to reputation cost companies millions of dollars each year.
How can a company protect itself from these threats? The first step in securing your company is to create an email usage policy. After you have created your email policy you must make sure it is actually implemented. This can be done by giving regular trainings and by monitoring employees' email using email security software. "

Labels: General, Policy

Email Photos

1. Send the photo as an attachment to an email. It'll show up as an icon at the top of the email for the receiver to click and open in their picture viewer. This is the most common option.
   
2. Embed the photo into a HTML formatted message so it appears in the text of the message just like a photo in a newspaper article. This looks nicer for people who want to read the message and not necessarily work with the photo file. But there are compatibility issues to keep in mind.

Whichever way you choose, you need to keep an eye on the overall size of the message. With higher resolution cameras available it's easy to go over the recipient's limit for incoming messages.

Labels: Attachments, HTML, Tips

The Good and the Evil

By default, Outlook 2003 blocks all HTML content that is referenced by an external location. Many junk e-mail senders put an image URL in the e-mail message. The image URL notifies the junk e-mail senders' Web server when you read or preview the e-mail message. This type of image URL is also known as a "Web beacon." An example of a Web beacon image URL is:

<img src="http://myserver/cgi-bin/program?e=your-e-mail-address-here" />

If you preview or open an e-mail message with this type of an image reference, this action may make you a target to receive more junk e-mail messages.

To prevent this type of Web beacon, where an HTML e-mail message contains references such as links and banners to an external URL, the Outlook 2003 HTML viewer does not automatically render the external content. Instead, when you view the e-mail message, areas in the e-mail message that should have a picture appear as a red X placeholder.

Click here to download pictures.
To help protect your privacy, Outlook prevented automatic download
of some pictures in this message. 

1. Open Outlook
   
2. Click Tools menu
   
3. Select Options
   
4. Click the Security tab
   
5. Click Change Automatic Download Settings button
   
6. Select when you want pictures downloaded
   
7. Click OK OK

Labels: General, Spam, Tips

Fresh look

Labels: General

A multidiscipline subject

Labels: General

Startup flags

The Microsoft Outlook Help file contains an entry that lists command-line switches, which you can use to start Outlook in a specific mode or with a specific form.
This article lists additional command-line switches that are not included in the Outlook Help file.

/sniff

Starts Outlook, forces a detection of new meeting requests in the Inbox, and then adds them to the calendar

Labels: General, Shortcuts, Tips

Shut them down

1. Go to Tools>Options.
   
   
2. In the Options dialog box, select the Preferences tab.
   
   
3. Click the E-Mail Options button.
   
   
4. In the E-Mail Options dialog box, click the Tracking Options button.
   
   
5. Choose the option Never send a response.
   
   
6. Click OK.

Labels: General, Tips

or not

Labels: General, Tips

See it all

. . . you can view the header and source together in the options dialog, if you edit a registry key. This works on mail downloaded from Internet mail transports only, not Exchange server mailboxes. However, if you Access the mailbox using an Internet transport, you'll see the full source.
Open the registry editor and navigate to:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Options\Mail

Right click on the right pane and choose new DWORD:

Parameter: SaveAllMIMENotJustHeaders
Value: 1

Labels: General, Tips

Look again

Search Folders are a kind of new user interface for the Advanced Find functionality, which has been with us through several Outlook generations. The thing that makes Search Folders new and unique is the possibility for defined search criteria to be saved and represented through a kind of virtual folder in the Outlook client. What this means is it gives us a virtual folder view of the content in one or more "normal" folders, for which a search criteria has been defined.

Labels: General, Tutorials

What's the Outlook?

"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."

Labels: Access, Email, Tips, Tutorials

Auto Archive

Labels: PST

The bounty that is a right click.

• Right click on Outlook's group headers to Collapse All or Expand All
  
  
• Right-click your calendar and choose Open in New Window. When you do, Outlook opens a new window for your calendar and you can toggle back and forth using the Windows taskbar
  
  
• Right-click the message in the message view window and select Options. The box "Request a read receipt for this message" under Tracking Options will have a check in it if the message was sent with a read receipt
  
  
• Right click in the middle of the file name if there is a file attached. You will see the option box with the choice of Print, Save As etc…
  
• 
  
• Right the name in the email you receive if you want to add to the contact list. click on Add to Contacts in the context menu and entry for the contact will open with the name and e-mail address already filled in. Fill in the other details if required and save the contact
  
  
• Right-click the folder you want to search in the Folder List or Outlook Bar and select Advanced Find
  
  
• Right click on the Day planner's time scale to change the scale or Access Time Zone settings.
  
  
• Right click Personal Folders and choose Properties. Select Folder size to see the size of your PST
  
  
• Right click on any Day/Week/Month view for a host of options, include Go to Day...
  
  
• Right click on folders (including shortcuts on the Outlook bar) to see folder options
  
  
• Right click the Deleted Items folder Click Empty Deleted Items Folder on the shortcut menu.
  
  
• Right -click the folder you want to Archive, and then click Properties on the shortcut menu. Click on the AutoArchive tab. Specify whether you want to archive this folder and it so, whether to use the default AutoArchive settings or your own settings
  
  
• Right click on any white pace in any folder view to Access view options. (Double click in white space to create new items)

Labels: Shortcuts, Tips

Junky appearing addresses

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

f.r.e.d.a.g.g@gmail.com

"Frederick Dagg"@freddagg.com

Fred+sheepdip@freddagg.com

Fred*Dagg=funny@freddagg.com

FredO’Dagg@freddagg.com

Bruce^Bayliss@freddagg.com

Prof~Taihape@freddagg.com

FD{Prof}@freddagg.com

Pa$toral@freddagg.com

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

Labels: Email, General

Pick your own location

"With Outlook closed, open Control Panel and double-click Mail. (Type Mail in the Search box.)
In the Mail Setup dialog box, click Data Files and then click Open Folder. This opens Windows Explorer using the folder where your Outlook Personal Stores (PST) file is located. The default name is Outlook.pst. Back up that file, which contains all your messages, rules, contacts, and appointments."

Labels: General, PST, Tips

Fill the managers Sent file

When messages and meeting requests are sent by a delegate, on behalf of a manager, a copy of each item is saved in the delegate's Sent Items folder; this behavior is by design.

To save sent items to the manager's Sent Items folder and not the delegate's Sent Items folder, the delegate must be logged on as the manager. This may not be acceptable because of privacy or security concerns. By design, items that are sent by a delegate cannot appear in someone else's Sent Items folder.

A solution is for the manager to grant permissions to their Sent Items folder to the delegate. The delegate can then move or copy the items from their own Sent Items folder to the manager's Sent Items folder after they open the manager's mailbox as an additional mailbox. To do this:

1. In the Folder List, right-click the Sent Items folder, and then click Properties.
   
2. On the Permissions tab, click Add.
   
3. Click to select the delegate from the address list, click Add, and then click OK.
   
4. Click to select the newly added name, and then click to select the appropriate permission level. Note that the Non Editing Author option is the minimum permission to set.
   
5. Click Apply, and then click OK. Repeat the previous steps for the Outlook Today root level folder.

Labels: General, Tips

Click to create

mailto:doug@example.com,bill@example.com?subject=Centennial report&Body=This week's activities

Labels: General, Shortcuts, Tips

Let's get hyper

Any Internet address that you type into an Outlook message or other item becomes a hotlink that other Outlook users can use to get quickly to that resource.

For messages sent to non-Outlook users, the recipients' e-mail software determines whether the links are hot or not. Most e-mail software today supports hotlinks.

Just typing an Internet e-mail address does not create a hotlink that Outlook users can click on; you need to use the fully qualified URL with the mailto: or http:// prefix.

Labels: General, Links, Tips