Can anyone help?,
I've been tasked with creating a database to hold information on changes to
drawings, designs etc. The database would be required (if at all possible)
to send an automatic email to some (or all) parties on a list when new
information pertaining to their department or section was input to the
database.

I was thinking along the lines of:
Table 1 - for holding the information
Table 2 - for list of persons and departments (to include email addresses)
Query 1 - to link data from Table 1 and Table 2
Form1 - to input information into Table 1
Report 1 - to be used by macro (as snapshot). Will show parties who need to
action new information input to table 1.

My problem is I've not written macros in Access 2003. Is there any way to do
this automation?

Thanks in advance.
Bob S.

Bob,

I haven't written a macro in Access for years, I prefer to do everything in
VB, however, if you want to use macro, sect the event you to run the macro
from the properties sheet of the form or the field, , click on the three
dots (..) select the "Macro Builder "Name the macro,it and use the builder
to it for you.

Regards/JK

"Bob Seymour systems.com>" <bob.seymour@bae<spamtrap> wrote in message
news:(E-Mail Removed)...
> Can anyone help?,
> I've been tasked with creating a database to hold information on changes
> to drawings, designs etc. The database would be required (if at all
> possible) to send an automatic email to some (or all) parties on a list
> when new information pertaining to their department or section was input
> to the database.
>
> I was thinking along the lines of:
> Table 1 - for holding the information
> Table 2 - for list of persons and departments (to include email addresses)
> Query 1 - to link data from Table 1 and Table 2
> Form1 - to input information into Table 1
> Report 1 - to be used by macro (as snapshot). Will show parties who need
> to action new information input to table 1.
>
> My problem is I've not written macros in Access 2003. Is there any way to
> do this automation?
>
> Thanks in advance.
> Bob S.
>
>

Thanks JK, I'll give it a whirl.

"JK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Bob,
>
> I haven't written a macro in Access for years, I prefer to do everything
> in VB, however, if you want to use macro, sect the event you to run the
> macro from the properties sheet of the form or the field, , click on the
> three dots (..) select the "Macro Builder "Name the macro,it and use the
> builder to it for you.
>
> Regards/JK
>
> "Bob Seymour systems.com>" <bob.seymour@bae<spamtrap> wrote in message
> news:(E-Mail Removed)...
>> Can anyone help?,
>> I've been tasked with creating a database to hold information on changes
>> to drawings, designs etc. The database would be required (if at all
>> possible) to send an automatic email to some (or all) parties on a list
>> when new information pertaining to their department or section was input
>> to the database.
>>
>> I was thinking along the lines of:
>> Table 1 - for holding the information
>> Table 2 - for list of persons and departments (to include email
>> addresses)
>> Query 1 - to link data from Table 1 and Table 2
>> Form1 - to input information into Table 1
>> Report 1 - to be used by macro (as snapshot). Will show parties who need
>> to action new information input to table 1.
>>
>> My problem is I've not written macros in Access 2003. Is there any way to
>> do this automation?
>>
>> Thanks in advance.
>> Bob S.
>>
>>
>
>