+ Reply to Thread
Results 1 to 6 of 6

[VBA] synchronise or combine data between outlook agenda and excell

  1. #1
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    office 365
    Posts
    60

    [VBA] synchronise or combine data between outlook agenda and excell

    Hello everyone,
    I was looking for a solution to synchronise oulook agenda and an excell sheet.
    I was searching on the forum, but the only thing i found was something with VBA. But i do not understand that.
    I have an excell with different tabs. One of the taps is a kind of project todo list with name startadres starttime and endadres. (I can upload if necessary).
    Do i need to make a formula or code in the excell to synchronise with the agenda? Or do i need a code or formula in agenda to synchronise in excell?
    The data from C till G is the agenda point.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,824

    Re: synchronise or combine data between outlook agenda and excell

    Unfortunately, this cannot be done without VBA code.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    office 365
    Posts
    60

    Re: synchronise or combine data between outlook agenda and excell

    I already thought so.
    But is it very hard to make use VBA?
    Or is it very complicated?
    The excell sheet i send was just an example. The sheet is more complicated and i can manage to work sheets together and ia m a bit experienced with making frmules and combine sheets.
    So the question is of i can manage the vba with a little help.
    I saw some vba lines you have to put smewhere, but i dont now how.
    Thx Roland

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,824

    Re: synchronise or combine data between outlook agenda and excell

    I will move this to the VBA section.

    One of our VBA experts will be able to advise as to the complexity of this and whether you'd be able to manage it as a novice.

  5. #5
    Registered User
    Join Date
    09-05-2018
    Location
    harderwijk nederland
    MS-Off Ver
    office 365
    Posts
    60

    Re: [VBA] synchronise or combine data between outlook agenda and excell

    okay thank you, i didn't know of this question was for the VBA section. Thats why i put it in the office section.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,824

    Re: [VBA] synchronise or combine data between outlook agenda and excell

    I know, but as I have said, this can't be done without VBA, so I have moved it to a more appropriate place.

    Someone else will take it from here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-14-2018, 08:32 AM
  2. Synchronise Outlook Task's with a Excel Spreadsheet
    By Mladenov in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2017, 07:24 AM
  3. Excel VBA macro to outlook shared agenda
    By mikeyy30 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2015, 09:30 AM
  4. Synchronise excel date to Outlook Calender
    By Geoff.D in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 07-26-2012, 07:12 PM
  5. [SOLVED] Can I connect data from Outlook contacts to cells within Excell?
    By Sean T. Newton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Can I connect data from Outlook contacts to cells within Excell?
    By Sean T. Newton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Can I connect data from Outlook contacts to cells within Excell?
    By Sean T. Newton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-08-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1