Simple notification on update

Matty2470 · Mar 13th, 2002, 01:00 PM

Somebody updates a workbook.
And exits. I would like at this point for a notification to be sent to a list of email addresses, which contains a snapshot of the info that has just been added

A report has been added to the system about [cell.A1] submitted by [cell.A2]

easy?

Where do I start

NateO · Mar 13th, 2002, 01:12 PM

That's a big jump from error 1004.

Have you tried making the workbook a shared one? Tools-> Share workbook.

This will save changes from different users with comments in changed cells.

Nate

Matty2470 · Mar 13th, 2002, 01:15 PM

Hi Nate,

I have done the same Access, but I want to make this system a lot lighter - less fat.

I want people to be able to fill out a form they get through email. This form will update an excel workbook on a shared network. when this workbook is updated, I would like notification....

hmmmmm

is this tricky Nate?

NateO · Mar 13th, 2002, 01:19 PM

Tricky....Probably not too bad, depends on your e-mail system. Here's some code which I think uses outlook (I use Notes so I don't mess with Outlook code).

http://www.mindspring.com/~tflynn/ex...html#Send_Mail

Just need to mix it with a Workbook_BeforeClose(Cancel As Boolean) procedure or an auto_close procedure. And loop through your recipients.

Cheers,

Nate

[ This Message was edited by: NateO on 2002-03-13 12:54 ]

Matty2470 · Mar 13th, 2002, 01:45 PM

Thanks.....

I will have a look at it

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:00 PM	#1
Matty2470 New Member Join Date: Mar 2002 Posts: 24	Somebody updates a workbook. And exits. I would like at this point for a notification to be sent to a list of email addresses, which contains a snapshot of the info that has just been added A report has been added to the system about [cell.A1] submitted by [cell.A2] easy? Where do I start

Mar 13th, 2002, 01:12 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	That's a big jump from error 1004. Have you tried making the workbook a shared one? Tools-> Share workbook. This will save changes from different users with comments in changed cells. Nate

Mar 13th, 2002, 01:15 PM	#3
Matty2470 New Member Join Date: Mar 2002 Posts: 24	Hi Nate, I have done the same Access, but I want to make this system a lot lighter - less fat. I want people to be able to fill out a form they get through email. This form will update an excel workbook on a shared network. when this workbook is updated, I would like notification.... hmmmmm is this tricky Nate?

Mar 13th, 2002, 01:19 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Tricky....Probably not too bad, depends on your e-mail system. Here's some code which I think uses outlook (I use Notes so I don't mess with Outlook code). http://www.mindspring.com/~tflynn/ex...html#Send_Mail Just need to mix it with a Workbook_BeforeClose(Cancel As Boolean) procedure or an auto_close procedure. And loop through your recipients. Cheers, Nate [ This Message was edited by: NateO on 2002-03-13 12:54 ]

Mar 13th, 2002, 01:45 PM	#5
Matty2470 New Member Join Date: Mar 2002 Posts: 24	Thanks..... I will have a look at it