473,387 Members | 1,483 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Automatically Creating and Sending a Outlook Appointment

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
3 7496
"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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Akira | last post by:
Could someone tell me how to send outlook appointment email from asp page? I would like appointment email just like one outlook can send out. I tried to look for an answer for this, but it seems...
2
by: Kamyk | last post by:
Hello all! I have the following problem. I know how to create a mail in VB with a subject and people to send, but is it possible to create an Outlook appointment in VB, if it is possible, please...
2
by: Kamyk | last post by:
Hello all! I have created a function in VB which generate appointment in Outlook. Everything is OK, except one thing. I cannot send it automatically using a button in Access, because I don`t...
0
by: Georges | last post by:
Hi, Can anyone help me with this. I would like to create outlook appointment from a web application. I tried to look at the CDO, WebDAV and MAPI documentations without success. what is the best...
6
by: chuckdfoster | last post by:
Is there a way to create an New Outlook Appointment from an ASP.NET application? I would also need to check if Outlook is running first. Any suggestions, advice?
2
by: Ori :) | last post by:
I am writing an application to retrieve appointments from Outlook, I have the appointment items sorted by "Start" field and now I want to find the first record which's "Start" value is later than...
0
by: keri | last post by:
Hi everyone, I have searched for info on this topic but have not found anything. Basically I have a db that posts appointments to outlook. I would like to be able to set all of the outlook...
4
by: reyalberto | last post by:
I am interested in creating an online appointment page where my clients can login and set an appointment with me. I'm somewhat familiar with PHP, but would like to know how should I go for creating...
5
by: mattkorguk | last post by:
Hi, Following the introduction of an appointment booking system in Access I've now given myself another issue. As I'm sending lots of appointments out I'm also then getting lots of the same...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.