+ Reply to Thread
Results 1 to 2 of 2

[Excel VBA] Tasks from Excel sheet in Outlook

  1. #1
    Registered User
    Join Date
    02-22-2020
    Location
    Portsmouth
    MS-Off Ver
    Office 2019
    Posts
    2

    [Excel VBA] Tasks from Excel sheet in Outlook

    Hi everyone!,

    I am a newbie in VBA and macros and I am wondering if it's possible to import a tasks list from Excel to Outlook and get instant pop ups (eg. one your before the task deadline) basing on that list.

    The problem is that not the whole date is in one cell.
    Dates are in column A while hour of task in row 4.
    The task is on the intersection of these lines (column A & row 4).

    Once the task is found I would like to assign it as task with the appropriate date and time in Outlook to get automatically pop ups.

    Could anyone can help me how to start?
    Sheet with tasks and print screen attached.

    Thank you in advance!
    Attached Images Attached Images
    Last edited by Thoro; 02-23-2020 at 05:54 AM.

  2. #2
    Registered User
    Join Date
    02-22-2020
    Location
    Portsmouth
    MS-Off Ver
    Office 2019
    Posts
    2

    Re: [Excel VBA] Tasks from Excel sheet in Outlook

    I have already resolved the problem with structuring my data into a decent form ready to be uploaded to Outlook.

    Is there any possibility to upload the list like attached using VBA instead of Import or Export Wizard?

    Thanks!

    Attachment 664159

+ 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. Sending Tasks from Excel to someone else's Outlook
    By Rivendare in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2015, 06:42 PM
  2. Export Outlook tasks to Excel
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-28-2014, 12:45 PM
  3. VBA to sync Excel To-Do sheet with Outlook Tasks (2010)?
    By mauxhall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2013, 05:53 PM
  4. Excel to set tasks in outlook
    By carloskev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-22-2011, 07:00 AM
  5. Exporting from Outlook Tasks to excel
    By Chris_john Turner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2005, 08:05 AM
  6. I am trying to export MS Outlook tasks into excel
    By Excel programming in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2005, 06:10 AM
  7. [SOLVED] Outlook Tasks assigned from Excel?
    By Don Rouse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2005, 05:06 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