View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Automaticaly Emailing A S/Sheet ??

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...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.

--
Regards,
Tom Ogilvy


Neil wrote in message
...
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 he 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