ExcelBanter - View Single Post - How to Create an Excel Macro to send a meeting request.

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

--
Don Guillett
SalesAid Software

"DM HD" wrote in message
...
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.