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
Bookmarks