Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro to insert ACT 6 contact details (Word 2003)

    Hi all

    Woody & Ed's amazing bible "Using Office 2000" contained a great little macro for inserting details of an Outlook contact into a Word document. I'm now using ACT 6 to manage this kind of information which, of course, doesn't respond to this macro. ACT has a convoluted way of achieving a similar result, but it demands creation of an alternate set of templates (called ".ADT") which ACT invokes in Word. Duplicating my templates fails to excite my enthusiasm.

    Do any of you good folks have a macro that does this kind of thing directly within Word, i.e. in much the same way as Woody's classic?

    Grateful for any help you can offer.

    Best regards

    Neil

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Macro to insert ACT 6 contact details (Word 2003)

    I don't know, but I suspect it has been tried. <img src=/S/smile.gif border=0 alt=smile width=15 height=15> There is a section of the Act! support website, requiring a site registration, where you can download a software developer's kit. If you are inclined to try to program it yourself, I would look into that. For additional resources, you might try the Act! user forums, too.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Macro to insert ACT 6 contact details (Word 2003)

    ACT! was on sale at our local computer store, so I went ahead and did a bit of research on this. The SDK is available from this page.

    But first, a potentially time-saving aside, if you haven't already tried it. You can add ACT! as an Address Book in Outlook, and Word should then be able to access it through the same Insert>Address Book... dialog. (This is not on the menus in Word 97-2000-2002 by default, but can be added using Tools>Customize...; I have no idea about Word 2003.) Does it work?? (Here's a picture of the dialog, from Outlook I assume.)

    Building your own address book interface could be time consuming. There is a method to search for a name, but I don't see a "ready to use" pre-built dialog in the SDK. (Perhaps there are third party products?)

    Dim objDatabase as object
    Set objDatabase = CreateObject("ACTOLE.DATABASE")
    objDatabase.Open dbName
    'Perform Lookup - will return all records whose name begins with Chris
    objDatabase.CONTACT.Lookup CF_Name, "Chris", 1

    Note: CF_Name is a constant you'd have to define in your code as the number 26; the search finds records beginning with Chris (followed by any number of characters).

    Anyway, it's not something I could dive into without a tremendous incentive. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to insert ACT 6 contact details (Word 2003)

    Jefferson g'day

    Thanks for your response on this one - there weren't too many for this query.

    I indeed have ACT set up as an Office address book, and the "Insert Names" function does work - sort of. Outlook is perfectly happy using the ACT address book for addressing emails, but Word is a little less co-operative. The toolbar button you described inserts the name, but that's all - what I was hoping for was other address details (i.e. for correspondence).

    I figure that if Word can find the name, it should be possible to persuade it to dig a little deeper to get other fields - but then I am almost totally ignorant of what takes place under the hood, so my perspective may be skewed.

    Best regards

    Neil

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Macro to insert ACT 6 contact details (Word 2003)

    I think what takes place under the hood using Outlook is that it shares information with Word and Word plucks out specified fields that it wants to use. There is a hidden AutoText entry called AddressLayout that the dialog uses (described in more detail on Sue Mosher's Slipstick site in Inserting Addresses into Microsoft Word Documents). Phil listed the names Word recognizes in <post#=300855>post 300855</post#>; I suspect that ACT! doesn't use the same names, so that could be the problem. (Or maybe it's broken on purpose. <img src=/S/wink.gif border=0 alt=wink width=15 height=15> )

    Maybe you can replace the AddressLayout with one that works with ACT!, but finding zero hits in Google is somewhat discouraging. Anyway, if I try out the program and come up with anything else, I'll post back.

  6. #6
    Star Lounger
    Join Date
    Sep 2001
    Location
    Perth, Western Australia
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro to insert ACT 6 contact details (Word 2003)

    Thanks again Jefferson - any advice will be much appreciated. (By the way, I posted a similar query in the ACT6 discussion group and got zero responses - you gotta love the Lounge for its friendly and helpful denizens!)

    All the best

    Neil

Posting Permissions

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