Microsoft Issues database template

I don't use this template, but I've downloaded it and can try to help you.

<send email feature>
...Are you referring to the "Email Data Collection" feature, or are you just wanting to send an email?

< Basically I am trying to send an email to either a particular contact or a group of contacts  (assigned to)regarding the issue that I am requesting that needs attention.>
...Are these Contacts in Outlook or just people with email addresses listed in the database?

"Sending an email" can either be incredibly simple or incredibly complex depending on your exact needs and skill level.

At the low end sending an email is as simple as this:
DoCmd.SendObject acSendNoObject, , , "Somebody@SomeEmail.com", , , "Your Subject", "Your email Body Text"

So you will have to be *very* specific on your *exact* needs here...

JeffCoachman

You also need to be specific on your version of Access.   Do I understand you are trying to code this is Access 1997?

Hi guys,

My apologies for not responding earlier.

1. Yes my current version is A97.

2. I have not tested the issues template (A03) thoroughly but having seen it and given that I was working on a similar database, I thought it would be a great idea if I could set out the task details in a form and then select the individual to whom I want it assigned to OR assign it to a group of individuals.

The email I am envisioning in would require a

1. To

2. BCC (no need for CC because as I mentioned previously it would be eithe to an individual or a group. The idea of the BCC, in case I have to submit the email to a Non-IT manager!

3. Subject (which could be picked up from the form, I suppose)

4. Task (which would be picked up from the form itself)


I was wondering whether task details would need to go as part of an attachment?

I would be grateful for assistance. If you require more info please let me know.

Thanks

Hi guys,

I can upload what I have so far, if anyone is wants to have a look.

Thanks

My copy, here goes! Please note it is unfinished.
testtasks.mdb

There is macros, where you can do all your tasks, filling fields. May be you can explain where you have problems?

Hi,

 it doesnt work as I want it to:

The macro opens outlook Express (My default email application)

1. I cant get it to pick up the email of the person  or the group the task is assigned to.

2. I cant assign it to a specific template which I have.

My concern is that I have copied and amended the macro from the Issues Database (A3) and adapted it to this A97 database

Hi,

I almost forgot. The moment I include an entry for the task description, Outlook Express opens a new email and ignores my email template.

I hope I am making some sense

Thnaks

Gosh! boag you are thorough :)

Ok I'll start from the back.

1. yes I would have preferred to use vba code but since I saw this Microsoft database I thoght I could copy the idea of the macro to the database I was developing.

2. No I cannot upgrade as it stands. I am using A97 on a XP platform.

3. I dont know whether you've seen my uploaded database. The idea is that a form is filled in detailing the task to be carried out. There is a button which initiates the send email. You make the good point which is whether I want to preview the email first. The answer is yes.

4. The email addresses is not part of the Contact lists of Outlook Express. These addresses form part of database (These are found in the tbl_Assignee). that table also includes a names belonging to the group - Please see the table for this.

5. By using the macro method, it seems that by using  SendObject I am able to include certain things as part of the email, i.e. Subject, message, etc.
I used these "attributes to try and facilitate the preparation of the email. Somehow it is picking uo the person or group to whom to send to.
It is picking up the Subject (picked up from the Form) but thats about it. I've also included a Message text (picked up from the form) but the moment I do that it does not pick up the template file (this template file is not in my upload)

6. i am willing to accept a similar solution either using an attachment (a report) or some other method to achieve my idea.

 I think I have covered everything but if i am missing out on something please let me know!!

Version 2 - PLEASE IGNORE PREVIOUS POST -

Gosh! boag you are thorough :)

Ok I'll start from the back.

1. yes I would have preferred to use vba code but since I saw this Microsoft database I thoght I could copy the idea of the macro to the database I was developing.

2. No I cannot upgrade as it stands. I am using A97 on a XP platform.

3. I dont know whether you've seen my uploaded database. The idea is that a form is filled in, detailing the task to be carried out. There is a button which initiates the send email.
You make the good point which is whether I want to preview the email first. The answer is yes.

4. The email addresses is not part of the Contact lists of Outlook Express. These addresses form part of database (These are found in the tbl_Assignee). That table also includes a names belonging to the group - Please see the table for this.

5. By using the macro method, it seems that by using  SendObject I am able to include certain things as part of the email, i.e. Subject, message, etc.
I used these "attributes" to try and facilitate the preparation of the email.

Somehow it is not picking the person or group to whom to send to.
It is, however,  picking up the Subject (picked up from the Form) but thats about it. I've also included a Message text (picked up from the form) but the moment I do that, it does not pick up the template file (this template file is not in my upload)

6. I am willing to accept a similar solution either using an attachment (a report) or some other method to achieve my idea.

 I think I have covered everything but if i am missing out on something please let me know!!

For Number 3, my question here is *When* you want the email sent out.

Again, forcing the use to click a button is problematic because they can forget, or click it twice.

Is your goal that each time a person gets a new task, you want to send them a email?

Hi,

Thanks boag2000,

My initial idea would be to force the user to click the button.

However you make a good point! Perhaps before closing the form it might be an idea to stop the user exiting the form until the email has been sent.

Have you seen my uploaded database? Is there any chance of carrying out what I am suggesting?

Thanks

Hi all,

I've amended my database so that I can send it to the emails either to an individual or a group.

However, I aleardy have an email template file in html format but when I write out the path where the template is located, the email sent does not pick up the template but rathers sends a new email to the pertinent Assignees with the everything else , i.e. Subject and  Message text.
testtasks3.mdb

Hi,

I am trying to improve and simplify my explanation and provide a sample database (done in A97) .

 I have the following so far:
* Using A97
* a template created for Outlook Express.

The database (see attached)

An input form where all the info related to a task is inputted.

As it stands: the database works "nearly" as required.

The problem I am haviing occurs when I want to send an email to a designated user/users

If I do not fill in the Task Description in the Input form, the send email works well, i.e  My own Outlook express template is picked up automatically, and so is the To: and Subject:

However when I additionally populate the Task Description field and send the email, the template is not picked up and instead a blank email comes up.
Note  -  To: and Subject: are picked up

Grateful if there is a way on ensuring that the outlook express tempalte is picked up.

Hope this is more clear.
testtasks5.mdb

Hi all,

I am still trying to figure this one out.

I was wondering whether if I change whole thing. Rather than use a macro to send the email I was wondering whether it was possible to use some VBA code.  So far I have read up on this but I am not achieving my aim.

grateful if someone could assist me with the code.

As way of reminder, I have a form which will provide the details that I want with my email. (Please note that I do not want an attachment to my email)

Please see my uploaded database.

To = txt_sendemail
Subject = Task
Message Text = Task Description
template  = c:\email.htm

Hi all


I am trying this code but to no avail:

DoCmd.SendObject acSendNoObject, , , "txt_sendemail", , , "Task name", Forms!["frm_ProjectIssueLog"]!["Task Description"], True, "c:\email.htm"

Grateful for assistance

Try
 Forms![frm_ProjectIssueLog]![Task Description]
or me.[Task Description]

Thanks als315 but it doesnt work, i.e. the text in the Task Description does not appear in the body of the email   !!!

Problem is in Access 97. I have no Access 97 and this template is not working without conversion. I will ask other experts. May be anybody have Access 97.

The database can be converted upwards , no probs.

Yes, but you need working DB in Access 97. Some things will work in next versions of Access, but will not in Access 97. In Access 2010 I can save only to Access 2000 format or higher.

I have distributed the points.