Inputing a range or reminders in outlook from excel

Hi Guys,

This should be a fairly simple question for most of you but I am new to this.

I am using the following script to place reminders in outlook from excel.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

However I have a large list of reminders I need to add from the spreadsheet (its a list of every employee and their annual review date).

How can I make the inputs (ie. "L4") a range (ie. "L4:L8") so that each row creates a new reminder with a new name and date? I get an error if I try to extend the range simply by entering "L4:L8"

Any help would be appreciated.

Cheers

Hi Doyl3

Welcome to the Forum!

Please wrap your Code in Code Tags (see Rule #3)

To do so highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

After you've done so try this Code

Please Login or Register  to view this content.