Results 1 to 4 of 4
  1. #1
    tostgulen is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    9

    Categorizing meetings and tasks

    Hi

    I have created a code to send my meetings and tasks from Access to Outlook. My meetings and tasks are categorized in Access (etc. sales, courses, support, inquiries,...).

    How do I get the categories from Access to Outlook? I followed this guide to create my code: http://www.access-programmers.co.uk/...ad.php?t=31517


    The categories are color coded in Outlook and will help me keep track with a quick glance at the calendar.
    Last edited by tostgulen; 01-24-2013 at 05:56 AM.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If this is Solved, do you care to share your solution with others that read this Forum?

  3. #3
    tostgulen is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    9
    To assign categories to tasks / meetings in Outlook you need to use the command (?), I'm not into the language definitions jet, .Categories. Here it the code i used:

    .Categories = Me!KontaktKategori.Column(1)

    In my Categories table I have an autonumber as primary key at the first column and the name I'm looking for is in the second column. Therefor the ".Column(1)" ending.

    For this to work correctly, you need to define the categories in Outlook with the color you want and the same name as the categories in the Categoris table.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thank you for the description of your solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Sync outlook tasks
    By slickvick in forum Code Repository
    Replies: 0
    Last Post: 01-20-2013, 09:01 PM
  2. Categorizing table contents
    By Alaa Wasfy in forum Database Design
    Replies: 1
    Last Post: 11-07-2011, 02:41 AM
  3. Multiple tasks in vb code
    By JFo in forum Programming
    Replies: 8
    Last Post: 10-03-2011, 07:58 PM
  4. Replies: 3
    Last Post: 08-05-2011, 09:42 AM
  5. Categorizing Word documents with Access
    By radagast in forum Access
    Replies: 0
    Last Post: 06-14-2009, 12:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums