Routing to fax recipients

This form allows Routing To Fax Recipients By Radio Buton Selecti on And Outputs To A Word Document Which uses VB to Route.

Routing to fax recipients

The Form posts itself to Public Folder for review and forwards to an Attachmate 6.5 Monitoring PC, which compares mainframe and Datasheet information in order to forward mail and launch alert rules in users inbox assistants. The Password is ESP and reveals much in the way of practical validation, some of which applies 2 rules to the field criteria. Much in the way of linked fields provides a fixed length 143 character datastring for use in the automated monitoring process. The Word Document originally sat on a Network Fileserver but runs more quickly on a Workstation. You need to change the names in the page 3 of the form to reference an address and also to change the VBScript to reference real names which your client PAB or Global Address List Supports.

Import data from a personalized Calendar form to Access

This program in Vb import data from a personalized Calendar form to Access makes a query to get the data that are between two dates (for example: may 10 1999 and may 15 1999 )of a personalized Calendar form to Access, then the data are sent to a report (Crystal Report), so you can print the data in the way you want to look.

Multicolumn listbox

How to use a multicolumn listbox on a form that does not have an external data source

company-contact selector form

using an ado 2.0 standalone recordset to manipulate contact information.

internet x-header

this form allows users to add custom x-headers to outgoing internet messages.

forced enable macros

i found a very simple solution to force the user to open an item with the option "enable macros

modified search form

this form allows users to select folders to search and use recursive folder searching

fast search form

this is the new version of the search form. because many people have asked how they can search in the public folders and how they can display the found items. it is a little bit faster and has a shorter search routine.

printing through word

many companies that are using outlook are also struggling with e-form printing. the following generic script has been used in some to satisfy some of printing form requirements in my company.

stuffing formfields of a letter/memo

attached is a zip file that contains an example of stuffing the formfields of a letter/memo with outlook contact item data and printing it from a button on the custom contact item.

importing contacts from a text file into outlook

shows how to import contacts from a comma-delimited text file into an outlook contacts folder, using access as an intermediary

exporting calendar items to excel

shows how to export outlook calendar items to an excel
worksheet.

vb to extract keywords properties

ever try to extract keyword data into other applications, here's a short function, and a button to drive it.

display contacts in a combo box

displays contact names or fileas fields in a combo box on an outlook form, where one can be selected for further processing

find a text file and mail it

finds a text file located in one of the standard folders, and mails it as an attachment to an outlook mail message

conditional field validation

shows how to apply conditional validation to a field, based on the value of another field; the code runs from the form's write event

setting the date and time from code

shows how to set the date and/or time for an appointment to start from vbs code, using date/time information entered in text fields on a form.

extracting an attachment from a task and mailing it

demonstrates extracting and saving an attachment from a task item and mailing it as an attachment in a new mail message.

exporting contacts to a mail merge document

demonstrates exporting contacts in a particular folder to a word mail merge document of the form letters type (one letter per page), with a choice of using an access table or a text file as the data source forthe mail merge document.

exporting contact data from access to outlook

exports contact data stored in an access table to new outlook contacts, using a dao recordset to pick up the data from the access table, and the add method of the contacts folder's items collection to create new outlook contacts. also includes buttons to create different types of outlook items, and to list the outlook folders.

copying contact items to another folder

shows how to copy all items (or items filtered by category) to anotheroutlookfolder.

exporting outlook journal entries to a microsoft access table

this section shows how you can export information stored in an outlook journal folder into a microsoft access table. this can be useful if you are using the journal folder in outlook to keep a history of a project. you can store this information in microsoft access where you can sort and view it in several ways.

personalizing a presentation for a contact list

this code illustrates how you can personalize a powerpoint presentation for your outlook contacts, which can be an effective sales tool. the sample code iterates through your outlook contacts folder and copies a powerpoint presentation with a customized title slide for each contact. it then either e-mails the personalized presentation to the contact or saves the message in your inbox so that you can add text and send it later. this code can be run from a microsoft excel, word, or microsoft access module.

creating mailing labels from an outlook contact list using word

this code shows you how to create mailing labels from an outlook contact list using the mailmerge object in word. word recognizes a wide variety of mailing labels. these label types are identified by string names.

exporting a microsoft access table into an outlook contacts folder

this code shows you how to add a list of contacts, stored in a microsoft access table, to your outlook contacts folder.

parsing a multi-line address

shows how to parse two address lines in a multi-line contact address into separate variables representing line 1 and line 2, for exporting to another application.

access contact fields using cdo

anyone trying to read contact items with cdo 1.2 will quickly discover that contacts are not directly supported in this release, but that you can get the properties you need by using the field schema. there are a couple of "magic" bullets you need to get at the email fields (i.e. email1addrtype, email1address, etc.). specifically, you need a guid that represents the mapi propertysetid and a propertytag for the field.

persistent database example

this example demonstrates how to create a persistent database connection using a class object encapsulated in a dll.

convert a keywords type field

this code is vbscript code that allows you to convert a keywords type field (array of strings) into an array of variants.

viewing journal items

attached is a pst for the two forms that will allow workgroups to see all the journal items made for a contact, not just the journal items of the current user as they now have it.

exporting outlook contact info to word letters

this code sample exports contact name and address data from an outlook custom contact item to a choice of three word templates, using either a combo box or an option group. the outlook data is stored in custom doc properties in the word document. the commondialog control is not used on the outlook form.

it requires vbscript v. 2.

generating unique id's for contacts

this example demonstrates how to use vbscript 2.0 to do the following:

• acquire a unique contact id number from an odbc datasource
• fill a list box from an odbc datasource
• fill a combobox from an odbc datasource
• populate a keywords field from a listbox
• validate data using an odbc datasource
• add data to an odbc datasource
• use the property change event

instructions for adding or submitting code samples