create/assign Outlook tasks from a range of cells

**dftf** · 05-15-2008, 10:38 PM

I have had some help with this (thanks!) but am stuck.

Can someone add to the code below and make it so that multiple tasks, with multiple assignees, can be created from a range of cells, such as:
Column A Column B
Row 1 Task Subject Assign to
Row 2 GV LP for AZ John Brown
Row 3 GV LP for CO John Brown
Row 4 GV LP for IL Suzy Smith
Row 5 GV LP for IN Suzy Smith
Row 6 GV LP for KY Suzy Smith
Row 7 GV LP for MN Suzy Smith
Row 8 GV LP for MS Bob Barker
Row 9 GV LP for NC Bob Barker
Row 10 GV LP for NJ Bob Barker
Row 11 GV LP for NM Bob Barker
Row 12 GV LP for NV Bob Barker
Row 13 GV LP for NY Bob Barker
Row 14 GV LP for OH Bob Barker
Row 15 GV LP for SC Bob Barker
Row 16 GV LP for WV Bob Barker
(Sorry, it didn't translate well. The "GV LP for AZ" is cell A2, "John Brown" is cell B2.)

Here is the code I have so far:

Please Login or Register  to view this content.

This creates the tasks but assigns them to me.

Can anyone help?

I would also like to have a due date column, but it is not absolutely necessary.

Thanks!

David

**chrismann85** · 05-16-2008, 07:20 AM

I would wrap your code if I were you before you get told off

**mudraker** · 05-16-2008, 07:26 AM

dftf

Welcome to Exceltip forum

Please take a couple of minutes and read the Forum Rules then wrap your VBA code (Rule 3)

chrismann85

Thanks for trying to warn dftf

**dftf** · 05-16-2008, 11:20 AM

Thanks for the polite warnings. I am new to this stuff.

I can't find an edit button so I am reposting, hopefully in the correct manner.

Please Login or Register  to view this content.

I also read that I should attach a file so others can test the data without retyping. The file is named "template.xls".

Can anyone help?

Thank you!

David

**royUK** · 05-16-2008, 11:24 AM

Attach your file by replying to this thread, scroll down the page & click the Edit button. It's best to zip the file first.

**dftf** · 05-16-2008, 11:56 AM

Thanks - zipped file attached.

**dftf** · 05-21-2008, 02:53 PM

Bump no response

Thanks!

**royUK** · 05-22-2008, 04:10 AM

No attachment

**Andy Pope** · 05-22-2008, 05:14 AM

You need to add recipients and then assign

Please Login or Register  to view this content.

**dftf** · 05-22-2008, 10:44 AM

Originally Posted by royUK

No attachment

royUK,

I did attach a zipped file after your first post. It is in the post above, with the "Last edited by dftf : 05-16-2008 at 10:55 AM".

Sorry if I didn't make that clear.

Thanks!

David

**dftf** · 05-22-2008, 10:48 AM

Originally Posted by Andy Pope

You need to add recipients and then assign

Please Login or Register  to view this content.

Andy,

I am a real newbie with VBA.

Where do I insert your code?

At the end?

Please Login or Register  to view this content.

Thanks for your help!

David

**Andy Pope** · 05-22-2008, 10:50 AM

No it replace the current code you have by adding a couple of lines.

Please Login or Register  to view this content.

**dftf** · 05-22-2008, 11:14 AM

Whoo-hoo! Thanks Andy!

That did everything but send the task. Is there something that can be added to the code to make outlook send the task?

The reason I want to automate is that I frequently send out tasks to my team of 7 folks. Currently, I need to send out 15 tasks each, which is 105 tasks to create.

With this code, the typing, assigning, etc., is completed.

Is there a way to make outlook send the task too? Or am I stuck with clicking send 105 times?

Not that I can't click send 105 times, just don't want to.

Thanks again!

David

**Andy Pope** · 05-22-2008, 11:22 AM

To send I think you can use the Send method.
You may also want to add a Save in there as well

You may get the security warning come up as you try to resolve the recipients names. Just allow the action for as long as possible.

Please Login or Register  to view this content.

**dftf** · 05-22-2008, 11:30 AM

Now I have to click Yes at the security warning, wait about 5 seconds, then click Yes again, wait 5 seconds, ...

This repeats for all 15 of my test tasks.

Did I do something wrong? I pasted your code into this code (see below).

Please Login or Register  to view this content.

Thanks!

**Andy Pope** · 05-22-2008, 11:36 AM

As I said the security kicks in when you resolve the recipients.

You could try this. Comment out the .Send command and see if just saving it triggers the warning.

If that works you then need to try manually sending multiple tasks. If you can do it manually maybe you can with code and only get the warning once. If not I think you are stuck unless you get a third party tool which works around the security warning. Something like Redemption.

**aavvijit** · 03-22-2011, 06:01 AM

Originally Posted by Andy Pope

As I said the security kicks in when you resolve the recipients.

You could try this. Comment out the .Send command and see if just saving it triggers the warning.

If that works you then need to try manually sending multiple tasks. If you can do it manually maybe you can with code and only get the warning once. If not I think you are stuck unless you get a third party tool which works around the security warning. Something like Redemption.

Hi,

Can you please help to add two more column in the existing code, like .......
1. Start date
2. Due date

these will be the dates mentioned in the excel sheet in respective rows.

Thanks,

**Andy Pope** · 03-22-2011, 09:17 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.