Automaticaly Emailing A S/Sheet ??

[Neil]

Hi there,

im in the middle of doing a stationery spreadsheet in my office....and im
want to try and make it as easy as possible for all using it (they arent too
great with new apps on PC's)

file here: http://www.dj-jammy.com/order.xls

im want to have it so that, when the user has filled out their request, they
tick a box, and then hit a button, - then it will automaticaly send it to
the next person on the sheet, who hasn't ticked a box - then, when all are
ticked, it goes to a specified email address, im guessing i need some sort
of array, and then when the box is ticked, it takes the emai lout of this
array, and sends it to the next/first item in the array - or that kinda
thing..............

problem is, i dont know how to code a spreadsheet.............:-(


if anyone can help, i'd greatly appreciate it.

Thanks,
Neil

 

[Tom Ogilvy]

Here are some sources of information on mailing spreadsheets:

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/index.html

an Article by Ron on MSDN:
http://msdn.microsoft.com/library/en-us/odc_xl2003_ta/html/odc_xlmail.asp

Dick Kusileka's site
http://www.dicks-clicks.com

If you can't adapt that to do what you want, then you might consider hiring
a consultant to round out your app.

 

[Neil]

got it,

Private Sub CommandButton1_Click()

ActiveWorkbook.Save 'save sheet
ActiveWorkbook.Route 'send to next recipient on route list
ActiveWorkbook.Save 'save again, to sto annoying dialogue
ActiveWorkbook.Close 'close workbook

End Sub


neil