Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









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

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Tuesday, June 10, 2008 – Permalink –

Auto Link

Outlook Contacts in Access


Automatically set up links to data outside of Access.
It still works in Access/Outlook '07.

Try this:

  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.




The changes made in Access will be reflected in Outlook and vice versa.

If you want to create a new database that will link to other data that isn't in an Access format, you can do it quickly.

The classic way is to use the File>Get External Data >Link Tables method.

However you can simply choose File >Open from the menu bar.

Select the appropriate data format from the Files Of Type dropdown list
(such as Microsoft Excel (*.xls)).

Open the file and Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.

From there you can develop forms, queries and reports.



See all Topics

Labels: , ,


<Doug Klippert@ 7:48 AM

Comments: Post a Comment

  Monday, May 26, 2008 – Permalink –

View Pictures

All at once


This article walks you through the process of using VBA to develop a form that will allow you to open all e-mail picture attachments at one time.


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

Microsoft has replaced Photo Editor with a new photo editing and cataloging program in Office 2003 and 2007: Microsoft Office Picture Manager.

Here is how to reinstall Photo Editor from your Office XP CD:
Photo Editor is removed when you install Office 2003 or Office 2007




See all Topics

Labels: , ,


<Doug Klippert@ 7:02 AM

Comments: Post a Comment

  Monday, May 19, 2008 – Permalink –

Outlook/Exchange Newsletter

Words from the wise


Here is a 13-year archive of articles about Outlook and Exchange. From both a user's and administrator's perspective.

Exchange Messaging Outlook


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

Labels: , , ,


<Doug Klippert@ 5:27 AM

Comments: Post a Comment

  Monday, May 12, 2008 – Permalink –

Crime and Outlook

Investigative techniques



Email Headers

ForensicExams.org

Outlook-Tips.net:
Recovering Deleted E-mail

HTCIA.org

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




See all Topics

Labels: , , ,


<Doug Klippert@ 6:25 AM

Comments: Post a Comment

  Tuesday, May 06, 2008 – Permalink –

Outlook Power Magazine

Source site


One of the locations for information about Outlook and Exchange is OutlookPower.com.

Also available as a news letter, it contains a number of suggestions such as this one dealing with printing the notes area on the calendar:

Printing Contact notes
By Francine Otterson
"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

Labels: , ,


<Doug Klippert@ 6:42 AM

Comments: Post a Comment

  Wednesday, January 30, 2008 – Permalink –

E-mail Access Form

Question and collection


Access 2007 has a wizard that will walk you through the process of sending an information gathering form through Outlook. The wizard is on the External Data tab in the Collect Data group.




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


Collect data by using e-mail



See all Topics

Labels: , ,


<Doug Klippert@ 7:18 AM

Comments: Post a Comment