Sending out e-mails to people

  • Thread starter Thread starter Haji
  • Start date Start date
H

Haji

Hello,

I have created imput forms that is based on a table
called tickets. There is a field in this table called
Assigned to which is based on another table also called
Assigned to. The Assigned to table has the name, phone
and e-mail address of people. Basically A ticket is
created by filling out various text and combo boxes.
There is an assigned to combo box which reads data from
the Assigned to table and assigns the particular ticket
to a technician. What I would like to do is to have a
button somewhere that invokes outlook and sends out a
note to the particular technician. It would contain the
information for that particular record in the Ticket
table. I know it takes VBA code to do this but I don't
know much about VBA. Can anyone help?

Thanks,

Haji
 
There is sample code at the following links that can get you started:

MSDN article on creating appointments, emails, etc., using Automation
http://tinyurl.com/2knwj

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Also, have a look at Tony Toews' email page:

http://www.granite.ab.ca/access/email.htm
 
If all your information is on the form you could add a
command button that runs a macro which sends a report to
the technician based on the current record. Use the
Sendobject command in the macro. The To,CC,BCC,Subject,
and message text would reference the current record on the
form.
ex
To: =[Forms]![formname]![controlname]
subject: =[Forms]![formname]![controlname]

Jim
 
Jim/Chris,

Thanks for your help. I do have several reports that are
based on the Ticket Input form. These include: Tickets
by Requestor, Tickets by Status, Tickets by Company.
What should I do as a report in my macro? Also, I assume
they would get an e-mail with some text data based on the
report and not the actual MS Access Report itself? There
are several pieces of information on the form that are
important for the technician to know. It looks like I
need to convey what the technician need in the Subject
and Message Text fields.

Thanks,

Haji
-----Original Message-----
If all your information is on the form you could add a
command button that runs a macro which sends a report to
the technician based on the current record. Use the
Sendobject command in the macro. The To,CC,BCC,Subject,
and message text would reference the current record on the
form.
ex
To: =[Forms]![formname]![controlname]
subject: =[Forms]![formname]![controlname]

Jim
-----Original Message-----
Hello,

I have created imput forms that is based on a table
called tickets. There is a field in this table called
Assigned to which is based on another table also called
Assigned to. The Assigned to table has the name, phone
and e-mail address of people. Basically A ticket is
created by filling out various text and combo boxes.
There is an assigned to combo box which reads data from
the Assigned to table and assigns the particular ticket
to a technician. What I would like to do is to have a
button somewhere that invokes outlook and sends out a
note to the particular technician. It would contain the
information for that particular record in the Ticket
table. I know it takes VBA code to do this but I don't
know much about VBA. Can anyone help?

Thanks,

Haji
.
Click to expand...
.
Click to expand...
 
Back
Top