Put date into Outlook Diary

I

Irv1010

I have a field called [NextApptDate] and another called [NextApptTime] which
gives that date and time of the next appointment for a client. I would like
these fields along with the [ClientID], [Surname] & [Forenames] to go into my
Outlook diary as an appointment if I Dbl_Click the [NextApptDate] field.

I tried looking at the CodeWidgets.com entry which was suggested to another
question poster, but can't get it to work.

Can anyone help please.
 
S

Steve Schapel

Irv,

This will not be possible to do with a macro. You will need to use
Office Automation involving VBA coding. I suggest you re-post your
question to the externaldata newsgroup.
 
I

Irv1010

Will do. Thanks

Steve Schapel said:
Irv,

This will not be possible to do with a macro. You will need to use
Office Automation involving VBA coding. I suggest you re-post your
question to the externaldata newsgroup.

--
Steve Schapel, Microsoft Access MVP
I have a field called [NextApptDate] and another called [NextApptTime] which
gives that date and time of the next appointment for a client. I would like
these fields along with the [ClientID], [Surname] & [Forenames] to go into my
Outlook diary as an appointment if I Dbl_Click the [NextApptDate] field.

I tried looking at the CodeWidgets.com entry which was suggested to another
question poster, but can't get it to work.

Can anyone help please.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Put Date into outlook diary 0
MSgBox Yes No 5
VBA concatenate ranges into a new document 0
VBA - exporting serial letters to single documents 0
Date Time decimal value help please 1
Diary report 4
Calendar - Outlook 2007 1
Keeping A Diary/Appointments in Access DB 7

Top