Context Menu

Labels: Tips, Tutorials, VBA

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

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

Get started in the right direction

• Access
  
  
• Adobe Acrobat
  
  
• Dreamweaver
  
  
• Excel
  
  
• FrontPage
  
  
• Microsoft Office Tools
  
  
• Outlook
  
  
• Outlook Web Access
  
  
• PowerPoint
  
  
• Publisher
  
  
• Visio
  
  
• Windows
  
  
• Word Art
  
  
• Word

Labels: Tutorials

Choose the folder

1. Click Start, and then click Run
   
2. Type regedit, and then click OK
   
3. Locate the registry key that is appropriate for your version of Outlook
   For Outlook 2003:
   

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

   (Use 12.0 for 2007 etc.)
4. Right-click the DelegateWastebasketStyle value, and then click Modify
   
   If the key is not present, use the following steps to create it:
   
   1. Right-click the General folder
      
   2. Point to New, and then click DWORD Value.
      
   3. Type DelegateWastebasketStyle, and then press ENTER
      
      
   4. Change the value data in the Edit DWORD Value dialog box to one of the following values:
      8 = Stores deleted items in your folder
      4 = Stores deleted items in the mailbox owner's folder
      
      NOTE: Make sure that the delegate user has at least Author level rights for the Deleted Items folder of the owner's mailbox.
5. Quit the Registry Editor
   
6. Restart Outlook

Labels: Delete, Tips, Tutorials

Outlook, Excel, and VBA

• 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

Avoid header spaghetti

• To:
  
• CC:
  
• BCC:

"To see the Bcc addresses for messages that you sent, open the message from the Sent Items folder, then choose Actions>Resend This Message. If you don't see the Bcc box, choose Find>Bcc Field to display it. Another method you can use in the Sent Items folder, is to choose View>Show Fields and add the Bcc field to the current view. You may not be able to see all Bcc recipients that way if the list was a long one.

Labels: General, Tips, Tutorials

Keep the bots at bay

"Spam is an incredible problem and it is getting worse - your e-mail address is a commodity and if you put it on a web page, it WILL eventually be found, spammed and sold to other spammers. The problem is that you have a web page and you need to make it possible for people to send you e-mail from your page but you don't want to get bombarded with spam - what can you do?

First you need to understand what is likely to happen. The most likely scenario is that an e-mail harvesting robot will find your page and look though it trying to find e-mail addresses. This robot may be programmed to look for a particular list of possible characters on either side of the @ in your e-mail address or it may look for the "mailto:" in your e-mail link or any number of other tricks."

<script language="JavaScript">
<!-- Begin user = "myaddress"; domain = "mydomain"; document.write('<a href="\">');
document.write(user + '@' + domain + '</a>');
// End -->
</script>
<noscript>
Here goes some text that can be seen if Javascript is disabled.
</noscript>

Labels: General, Tips, Troubleshoot, Tutorials

A tutorial

"Many spoof emails look very real. While there are some telltale signs, it can often be difficult to identify fake emails. Whenever you get an email about your PayPal account, the safest and easiest course of action is to open your browser and log in to your PayPal account directly without clicking any links in the email.

Warning signs that an email about your PayPal account are fake include a generic greeting, a false sense of urgency, and links that don't include "https://www.paypal.com" immediately before the first "/".

Labels: Spam, Tips, Tutorials

Set your identity

If you have multiple email accounts you can use a different template for each account.

After creating the template, assigning it to an account and saving it, you can assign the template to a button.




Click the button and the selected template will appear using the assigned account to send the message.

Slipstick provides screenshots and detailed instructions.


Create a Template With the Account Selected



See all Topics

outlook

Labels: Tips, Tutorials

Group the contacts

Labels: General, Send, Tips, Tutorials

Let it follow you around

There are a couple of ways of doing it: forwarding and redirecting.

Message forwarding

When a rule automatically forwards a message you receive, it leaves a copy of the message in your Inbox or in the folder to which the message was originally delivered. The rule then adds the designation "FW:" to the beginning of the Subject line, changes the message formatting, and then forwards the message to the account specified by the rule. The recipient represented by the account also sees that the message came from you.

Message redirection

When a rule automatically redirects a message you receive, it also leaves a copy in your Inbox or in the folder to which the message was originally delivered. The rule then sends the message, unchanged, to the account specified by the rule. To the recipient, the message appears as though it came directly from the original sender. There is no indication that the message was delivered by way of your account.

Indiana University:
Automatically forward all of my mail to another address

Also:

Office.Microsoft.com:
Automatically forward messages to another e-mail account

James S. Huggins' Refrigerator Door has this information:
Creating Another Email Address

Slipstick.com:
Automatic Message Processing Tools


See all Topics

outlook

Labels: General, Tutorials

Seven days till vacation

You could use brute force to enter data in an Outlook calendar that would count down to an event. Creating separate entries rapidly becomes tedious.

Outlook MVP Diane Poremsky demonstrates a way to quickly combine a list in Excel (or other CSV type formats) with calendar entries in Outlook.

It boils down to creating a list and importing into an Outlook calendar.

Here are the instructions including screenshots:

From Outlook-tips.net
Create Countdown Calendar Items



See all Topics

outlook

Labels: Calendar, General, Tutorials

Outlook Contacts in Access

1. Choose File >Open from the menu bar.
   (Office button>Open in 2007)
   
2. Under Files Of Type choose Outlook().
   
3. Locate your Outlook PST files.
   
4. Choose Contacts, or if you have set up separate files for different groups choose an appropriate one.
   
5. The wizard walks you through the process of creating an Access database with a linked Contact table.

Labels: Contacts, Links, Tutorials

All at once

Office Developer Center:

Viewing Multiple Picture Attachments in Outlook 2003
By Eric Legault (Outlook MVP)

It helps to have some experience with VBA coding, but the instructions are clear and no other applications are needed other than the Visual Basic editor that is built into Outlook.

Eric Legault is also a blog contributor at Office Zealot.com
The source code for the MSDN article can be downloaded there. It includes the complete form as well as the code modules.

... "image viewers that use a Multiple Document Interface (MDI) are best suited as a custom viewer. It's better to have one application handle several open image windows than individual windows cluttering your Taskbar! A perfect application for this scenario is the Microsoft Office Photo Editor, but it is no longer bundled with Office 2003."

Labels: Attachments, Tutorials, VBA

Words from the wise

The suggestions come from Slipstick.com, so you know they're good.

The publication is available both as an e-mail newsletter and with RSS distribution.




See all Topics

outlook

Labels: General, Tips, Troubleshoot, Tutorials

Investigative techniques

"The High Technology Crime Investigation Association (HTCIA) is designed to encourage, promote, aid and effect the voluntary interchange of data, information, experience, ideas and knowledge about methods, processes, and techniques relating to investigations and security in advanced technologies among its membership."

Labels: General, Tips, Troubleshoot, Tutorials

Source site

"How you can print the comments contained in your Outlook Calendar.

Outlook Calendar has various printing options to choose from that provide some editing capabilities.

With the Calendar Details printing style, the notes area would be printed along, with all of the other Calendar details. Plus, this style will allow you to choose a range of dates to print, and gives you the option of printing each day on separate pages or continuously.

To change the printing style, select Print under the File menu. Next, select the print style you would like to use e.g. Calendar Details style. If you would like to edit this print style, select Define Style then Edit."

The headlines can also be added to your web site:
Outlook



See all Topics

outlook

Labels: General, Tips, Tutorials

Question and collection

"You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form.

The form is sent through Microsoft Office Outlook 2007 to your recipients, with your request for new or updated information.

When the recipients reply to your message, Access automatically enters their data into your database.

Labels: Access, Forms, Tutorials