Go here
http://www.rondebruin.nl/

--
Don Guillett
SalesAid Software
donaldb@281.com
"DM HD" <DMHD@discussions.microsoft.com> wrote in message
news:518D61E2-1D95-4C83-B208-2BD7C7132470@microsoft.com...
> I want to try and setup a Macro to send meeting requests to my teams
> calendar. What we do is use it to book are equipment setups.
>
> Right now we copy and past the requests in to meeting request to an
outlook
> calendar and send them to ourselfs. This way we see who is working on
what.
>
> What i want to do is put basic information in to an excel form.
>
> The form is going to have the following.
>
> Who the request is for.
> Who is assigned to the request.
> The date and time needed.
> The date and time returnd.
> Type of equipment request.
> Ticket number from our call logging system.
> Where the equipment is needed.
>
> The macro would need to send a meeting request with the above information
in
> the Subject line.
>
> It would be in this formate. "Equipment Laptop 1 for John smith (Assigned
to
> Mark) Call number 173829" The date and time needed would set the time
needed.
> So if John smith needed laptop 1 at 9am we would sent the meeting request
for
> the time 9am to 9:30am. We would also set the reminder to be 30min.
>
> Also we set a second meeting request to as and all day event for the
return
> date. Just so that we all now that we have to get the laptop back on this
> day.
>
> If you have any suggestions on how i can set this up would be great.