A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Journals: Import notes and assign to Contacts



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 27th 08, 09:09 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Journals: Import notes and assign to Contacts

Sue's on vacation.

#1. Look at the Utilities pages at www.slipstick.com to see what's available
out there, if anything.

#2. If you run that code you get prompted approximately 4K times for the
contact to link to that journal item. Without some cross-reference or
pre-defined linkages already established there really isn't much choice.

#3. If the contact name was in a property in the journal item such as
Mileage, generally unused, then code could read Mileage, look for a
corresponding contact name and then add that contact object to the Links
collection for that journal item.

None of us can answer for what MS features decides to provide for its
applications. Any gaps are filled because the applications are programmable.
MS could never provide every feature, utility and add-on that any arbitrary
person could decide was absolutely essential.

You can find code samples for the Links collection at www.outlookcode.com.
Search there on that term and use the code samples as a starting point for
your efforts. You can then post your code here if you have problems and
someone will probably help you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Lightjag" wrote in message
...
Ok thanks. I have a couple of questions:

OPTION #1:
Is there a 3rd party program that would import the journals (currently in
excel) for me, inorder to avoid writing code? I have limited experiance
with
code writing.

OPTION #2: Links.Add method:

http://msdn.microsoft.com/en-us/library/bb175245.aspx

I have approx 4k journals, this method appears that it "prompts the user
for
the name of a contact " one at a time.

What would be the procedure for the method:
a) Data in excel. import journals. now they are unlinked.
b) Run code "links.add" method in outlook, what happens next?

OPTION #3: change the mapping Method:
How would this process work?
a) "contact information is imported into a journal property" (not used):
ex/
birthday
b) "can do the import manually": using MSFT import wizard?
c) " write code to iterate the imported items and update each one with the
necessary link(s)." == if possible can you help me out with some code?

P.S. I would of thought MSFT would of made this process (importing linked
Journals) more automatic like with names, numbers and addresses. They
make
it very difficult trying to migrate from someone elses CRM package to
Outlook.


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Journals: Import notes and assign to Contacts Lightjag Outlook - Installation 0 July 11th 08 09:57 PM
Subject: Journals: Import notes and assign to Contacts Lightjag Outlook - General Queries 0 July 9th 08 08:50 PM
Journals: Import notes and assign to Contacts Lightjag Outlook - Using Contacts 0 June 25th 08 05:58 PM
Importing Contact Notes into Journals Lightjag Outlook - Using Contacts 2 June 19th 08 08:55 PM
Import contacts from Lotus Notes vit Outlook - Using Contacts 2 October 6th 06 10:08 AM


All times are GMT +1. The time now is 12:57 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.