Results 1 to 1 of 1

Automatically create a Task in Outlook when data in a cell is entered

Threaded View

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    Indy, IN
    MS-Off Ver
    Excel 2010
    Posts
    1

    Automatically create a Task in Outlook when data in a cell is entered

    Hi All,

    I know this has probably been touched on already however, I can't seem to find code that suites my specific needs and I am driving myself to frustration in attempts to write myself. So, any input or recommendations would be greatly appreciated!

    I have been tasked with tracking immigration for my company. The process requires a good amount of following up since I am dealing with the federal government. What I need is code that will automatically create a task 28 days from the date that is entered in the respective cell in column E. For example (and feel free to see attachment) row 1 is header row, employee name is Column A, Misc information is Columns B-D and date requested is Column E. So when a date range is entered in cell E2, E3, E4... etc. a task is created in Outlook with concatenated information form A2:D2, A3:D3, A4:D4...etc. This list could go for 100's of rows so I would like to use the column rather than a string of cells.

    I am novice when it comes to VBA so, again, any help would truly be appreciated.

    Thank you,

    -Thomas
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Create Outlook Task When Value <50 using adjacent cell as subject/title
    By indiegoober in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2013, 10:17 AM
  2. Create Outlook task from Excel link
    By ahmedomara in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-12-2013, 09:13 AM
  3. create new task folder in outlook
    By Josh_123456 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2007, 02:22 AM
  4. [SOLVED] How can i have Excel automatically set an Outlook task?
    By VT in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 06:53 AM
  5. Create Outlook Task from Data in Excel Row
    By Theresa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2005, 09:05 PM

Tags for this Thread

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