By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,644 Members | 2,423 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,644 IT Pros & Developers. It's quick & easy.

Automatically Creating and Sending a Outlook Appointment

P: n/a
Sam
My db looks after the hiring and lending of equipment, the form which books
out equipment hired prints a signout sheet and automatically inserts an
appointment into outlook advising the operator on the due date that a
particular hire is due.

I have used microsoft's automated appointment code to do this, what I would
also like the code to do is to email an appointment to the person hiring the
gear.

Knowing that you can email an appointment from within outlook and create an
appointment with access surely you can do both?

And for a challenge I don't want the appointment that is being sent to
reside in the operators outlook calender (if possible)

Thanks

Sam
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Sam" <sa********@hotmail.com> wrote:
My db looks after the hiring and lending of equipment, the form which books
out equipment hired prints a signout sheet and automatically inserts an
appointment into outlook advising the operator on the due date that a
particular hire is due.

I have used microsoft's automated appointment code to do this, what I would
also like the code to do is to email an appointment to the person hiring the
gear.
See the Access Email FAQ at my website.
Knowing that you can email an appointment from within outlook and create an
appointment with access surely you can do both?
Sure.
And for a challenge I don't want the appointment that is being sent to
reside in the operators outlook calender (if possible)


Now I'm confused. Your first paragraph states "automatically inserts an appt into
outllook" and yet here you don't.

Or did you mean you don't want the sent email to be inserted in the operators sent
box? If so one possibility might be to use a different profile. But I don't know
how to use profiles in Outlook or if that would be the best answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

P: n/a
Sam
Thanks for your reply Tony

Maybe I need to clarify what it is I am trying to do...

The form inserts an appointment into the outlook calendar of the person
operating the db, this brings up a "Hire Due" message on the due date of the
hire, this part works great. what I am trying to achieve is to get the same
form to email the customer with a similar appointment which will alert them
at the due date, this last appointment doesn't need to appear in the
operators calendar. It is ok in their outbox/sent items.

I will look at your Website as soon as it starts to work for me!

Thanks again

Sam

"Tony Toews" <tt****@telusplanet.net> wrote in message
news:vu********************************@4ax.com...
"Sam" <sa********@hotmail.com> wrote:
My db looks after the hiring and lending of equipment, the form which booksout equipment hired prints a signout sheet and automatically inserts an
appointment into outlook advising the operator on the due date that a
particular hire is due.

I have used microsoft's automated appointment code to do this, what I wouldalso like the code to do is to email an appointment to the person hiring thegear.
See the Access Email FAQ at my website.
Knowing that you can email an appointment from within outlook and create anappointment with access surely you can do both?


Sure.
And for a challenge I don't want the appointment that is being sent to
reside in the operators outlook calender (if possible)


Now I'm confused. Your first paragraph states "automatically inserts an

appt into outllook" and yet here you don't.

Or did you mean you don't want the sent email to be inserted in the operators sent box? If so one possibility might be to use a different profile. But I don't know how to use profiles in Outlook or if that would be the best answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 12 '05 #3

P: n/a
"Sam" <sa********@hotmail.com> wrote:
The form inserts an appointment into the outlook calendar of the person
operating the db, this brings up a "Hire Due" message on the due date of the
hire, this part works great. what I am trying to achieve is to get the same
form to email the customer with a similar appointment which will alert them
at the due date, this last appointment doesn't need to appear in the
operators calendar. It is ok in their outbox/sent items.

I will look at your Website as soon as it starts to work for me!


Unfortunately the upstream provider is having severe problems since about 11 am this
morning. I'd suggest going to www.slipstick.com. Also, for a good tutorial someone
just emailed me about email from outlook see http://www.jephens.com/howtoemail.asp

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.