Results 1 to 9 of 9
  1. #1
    DougLaakso
    Guest

    How to use Outlook 98 data in Word 97? (Word 97)

    What is the best source to find out how to use Outlook data in Word 97 documents?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Tallahassee, Florida, USA
    Posts
    901
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Um, do you mean accessing a single Contact or PAB entry from a document (such as a letter into which you drop an address), or merging multiple contacts into a letter?
    Karen

  3. #3
    DougLaakso
    Guest

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    After more invesitgation, I found the Letter Wizard and it does most of what I want. Does anyone know where or how I can modify it's screens? Or will I have to re-create the whole thing?
    I need to add 3 contacts to a letter (Addressee, Author & Writer), change the default of Personal Address book to Outlook Contacts, as well as limit several of the options.

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Hi Doug,

    The letter template should have the following in an AutoText entry named AddressLayout (all one word):
    <PR_DISPLAY_NAME>
    <PR_STREET_ADDRESS>
    <PR_LOCALITY>, <PR_STATE_OR_PROVINCE> <PR_POSTAL_CODE>
    (You may be able to cut and paste the above into your document. If you do, use Paste-Special... Unformatted text.) Actually, I think that the AutoText entry can be in a global template (including Normal.dot) but am not sure of this.
    For more information on this, I would recommend that you read the instructions in <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=0789718421/balancecheckbookA/> Special Edition Using Office 2000</A> by Ed Bott and Woody Leonhard (Que), pp. 312-318, 763-764. That gives a listing of the different codes that Word recognizes as well as a macro for getting rid of the "United States of America" in the built-in templates. They also recommend starting the letter from Word rather than from Outlook and give instructions on how to do this.

    If you buy <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=0789718421/balancecheckbookA/> the book</A>, a side-benefit is that the CD-ROM contains WOPR-2000 which lets you right-click in a document and call up your contacts list to insert names and addresses from the Contacts folder.

    You want to take a look at the letterhead system on
    <A target="_blank" HREF=http://www.addbalance.com/word/download/index.htm#LetterheadSystem>my download page</A> (addbalance.com/word/download/).

    Hope this helps.
    Charles Kyle Kenyon
    Madison, Wisconsin

  5. #5
    DougLaakso
    Guest

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Hi Charles,

    Yes, I have tried playing with AddressLayout and the fields. That works great if you only need 1 address. I potentially need 4 (Sender's, Reciepient's, Copied to' and the typists.) The letter wizard has 3 of the 4. Additionally, I need to add a text box that displays DRAFT information for the sender's approval.

    While I haven't tried WOPR lately, I don't think Woody or Ed would appreciate me buying one copy and distributing it to more than 2000 users. And buying that many copies is not practical. Also, we are still using Office 97.

    Your letterheads are very good, but I didn't see any of them that took advantage of Outlook's contacts.

    In reading many letters requesting how to make changes to the letter wizard and finding no responses, I am assuming that we cannot change this wizard. I really hope this assumption is incorrect, but I may have to write my own.

  6. #6
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Hi Doug,

    I would urge you to read the pages mentioned in <A target="_blank" HREF=http://www.amazon.com/exec/obidos/ISBN=0789718421/balancecheckbookA/> Woody's book</A> (if you haven't already). That book has the only documentation on the letter wizard that I'm aware of and basicly points out that you can use the letter wizard with any template, not just those that come from Microsoft. I'm sure it will give you a good start on your project. This is true even though you are using Office 97 and it is an Office 2000 book. The letter wizard didn't change that much (if it changed at all).
    Charles Kyle Kenyon
    Madison, Wisconsin

  7. #7
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Doug,

    Wizards are not an area I know anything about, but I was under the impression that you can customize a wizard by:

    Go to Explorer and change the file extension from ".wiz" to ".dot".
    Open the .dot file and customize the userforms and/or code as you wish.
    In Explorer change the file extension back to ".wiz".

    HTH,
    Gary

  8. #8
    DougLaakso
    Guest

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Hi Gary,

    Had not heard of the changing the ending. I tried it and got no further than just opening the wizard from inside Word.

    By using the method CreateLetterContent() just before the call to "ActiveDocument.RunLetterWizard LetterContent:=MyLetter" does allow me to set a few of the defaults. But, this still does not allow me to edit the actual wizard.

  9. #9
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: How to use Outlook 98 data in Word 97? (Word 97)

    Doug,

    I can't try this out since I no longer have access to Word 97, but if you can change the .wiz file to a .dot and then open it in Word, the next thing to try in order to edit the wizard is to go to the VB Editor (Alt + F11).

    You should be able to locate a userform (probably with multipage property) that represents the dialog box presented by the wizard. To edit the wizard, you would need to make changes to the userform and the code that's behind the userform.

    - the above is based on a hazy recollection of having read these instructions some time ago, so they may not necessarily prove to be correct!

    Gary

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •