Hi,

I am looking for advice as well as help with code if that is possible.

I have a spreadsheet where customer details are stored in a worksheet.
Imagine I had made an appointment with a customer called Jones. I would
like to click on the row where Jones customer details are stored and to
be faced with a form to enter the appointment details (the customer
details would be populated from the customer details in the row I had
clicked on). I would input the appointment time / date on this form and
this would add the appointment to outlook.

I have thought of a few different ways to do this but none seems
sensible or workable.

So I have a few questions.

Is a form like this possible in Excel or am I trying to make Excel into
Outlook? I cannot seem to get the logistics of the form clear in my
head.

I have tried creating outlook appointments from code based on entries
in an inputbox - this works fine except for the date / time which I am
obviously doing wrong. Is there a way to set the date and time of the
outlook appointment to defined variables in my code?

Is there a way to print the outlook calendar from Excel, and to
programatically set the print preferences?

Any other suggestions towards different ways of doing this would be
appreciated as I am unclear how to achieve the end result.