Hi all
Any help on this would be appreciated. I manage a call center that does
outbound appointment scheduling for a variety of clients. I need to create a
macro that would take certain information(Columns A, C, I, K, & L) from the
call sheet and paste it into a separate worksheet when Column N = xx .
Ideally, it would also Paste info from column L into a calendar so that the
caller nad client could instantly see their appointment times on a given date
in a weekly layout similar to the calendar in outlook. I have not been able
to find a calendar creator like this. We are a very small company and do not
have the CRM software needed.
Thank you again for any input

I would need to do some research, but at work the way it is done is by
sending an e-mail with an attahment. When the attachment is opened it
automatically adds an appointment to the persons e-mail.

I don't think you want to remotely get into anothers persons e-mail account
and create an appointment. There would be security issues doing this.

"GeorgeR" wrote:

Hi all
Any help on this would be appreciated. I manage a call center that does
outbound appointment scheduling for a variety of clients. I need to create a
macro that would take certain information(Columns A, C, I, K, & L) from the
call sheet and paste it into a separate worksheet when Column N = xx .
Ideally, it would also Paste info from column L into a calendar so that the
caller nad client could instantly see their appointment times on a given date
in a weekly layout similar to the calendar in outlook. I have not been able
to find a calendar creator like this. We are a very small company and do not
have the CRM software needed.
Thank you again for any input