Trouble creating outlook event from

Hey guys,

I was wondering if someone could help me get some VBA code to create a task in outlook and something to keep track which items have already been exported to excel. I only need to export the time, date and the subject. The rest is not important. It will be on a seperate worksheet. I am using office 2010. I have seen a lot of code around the web but it only shows the code and not the format and location where to enter the contents. All I want to do is create reminders for which I can define the time of the reminder and the text i want to be reminded of. And if possible a cell marked with a X or something if it already has been exported.

any help would be greatly appreciated!

and thanks in advance

I have found the following code on the net which does exactly what I need it to do, the only thing is I get duplicate events. Does anyone know the VBA code to prevent this from doing so? I am a complete noob in VBA

Please Login or Register  to view this content.

Hey John

Thanks for the link but I have a few questions. How do I know what to put where. Because the code I've got now does work in the following format: Name, Date, Time, Duration, Reminder.
As I said I don't know that much about VBA and I can't seem to make it up by looking at the code.

Thanks for taking the effort for looking in to this!

I only have the code I have posted beforehand (the one that works but duplicates)
The sample file is included in this post, the format is exactly the same and how it will be used in making the agenda.

I guess the name of the calendar is the default one, I am testing it with a @hotmail.com account but it also works with the companies' domain in the default calendar.

Thanks again!

Here you go

Thanks! this is exactly what I wanted, works like a charm! Thanks again for your help

Nick

Hey for some reason my last question did not get through. I was wondering if it is possible for the already scheduled message to popup only once, this as about 20 30 items are added each day and the boxes will pile up

Not having a message is a option as well, either that or one message like some items have already been scheduled and have not been added as confirmation

I'm going to try the code now, I'll you know the results!

Thanks again! works great and now does exactly what i need it to do thanks for all the effort you've put into it!

Nick