Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
I am trying to write a macro (with no success) to email multiple sheets to multiple users. When the user clicks Email button a macro should go through the avalable sheets and email each sheet to the owner. Ie.. The 401-K sheet should only be sent to and so on I am using Outlook as the mail client Thanks for any help I am really stuck. +-------------------------------------------------------------------+ |Filename: email-books.zip | |Download: http://www.excelforum.com/attachment.php?postid=3475 | +-------------------------------------------------------------------+ -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Hi
Look on my site for examples http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... I am trying to write a macro (with no success) to email multiple sheets to multiple users. When the user clicks Email button a macro should go through the avalable sheets and email each sheet to the owner. Ie.. The 401-K sheet should only be sent to and so on I am using Outlook as the mail client Thanks for any help I am really stuck. +-------------------------------------------------------------------+ |Filename: email-books.zip | |Download: http://www.excelforum.com/attachment.php?postid=3475 | +-------------------------------------------------------------------+ -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Thanks for the Relpy Ron de Bruin The URL you provided is not workin -- swieduw ----------------------------------------------------------------------- swieduwi's Profile: http://www.excelforum.com/member.php...fo&userid=2196 View this thread: http://www.excelforum.com/showthread.php?threadid=37809 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Try it again, it is working
-- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... Thanks for the Relpy Ron de Bruin The URL you provided is not working -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Sorry, sir, still nothing is there a way you can post examples here :) when I try to ping it get "Unknown host" -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Hi
is there a way you can post examples here To much there If you click on this link is it working then http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... Sorry, sir, still nothing is there a way you can post examples here :) when I try to ping it get "Unknown host" -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Well I still can't connect, Our firewall must be blocking sites from the Netherlands I have also tried by IP and I still can not connect the following are from tests I ran: Domain Type Class TTL IP www.rondebruin.nl. A IN 86400 62.45.114.2 62.45.114.2 ASN=15435[Destination Unreachable] www.rondebruin.nl at (agterdenbos.nl.) [Unknown] [Unknown - Firewall did not respond] --------------------------------------------------------------------- There was a communication problem. TCP_ERROR Problem Description The system was unable to communicate with the server. Possible Problem Cause * The Web server may be down. * The Web server may be too busy. * The Web server may be experiencing other problems, preventing it from responding to clients. * The communication path may be experiencing problems. ----------------------------------------------------------------------- I do not think we are blocking .NL sites, I am getting alot of unknowns from the DNS servers on your dns name. I am not sure what is going on. -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
email sheets 2,3,4,5 ect. to users from a list on sheet1
Strange
Try it at home or on a other system. you can look here also http://msdn.microsoft.com/library/de...odc_xlmail.asp -- Regards Ron de Bruin http://www.rondebruin.nl "swieduwi" wrote in message ... Well I still can't connect, Our firewall must be blocking sites from the Netherlands I have also tried by IP and I still can not connect the following are from tests I ran: Domain Type Class TTL IP www.rondebruin.nl. A IN 86400 62.45.114.2 62.45.114.2 ASN=15435[Destination Unreachable] www.rondebruin.nl at (agterdenbos.nl.) [Unknown] [Unknown - Firewall did not respond] --------------------------------------------------------------------- There was a communication problem. TCP_ERROR Problem Description The system was unable to communicate with the server. Possible Problem Cause * The Web server may be down. * The Web server may be too busy. * The Web server may be experiencing other problems, preventing it from responding to clients. * The communication path may be experiencing problems. ----------------------------------------------------------------------- I do not think we are blocking .NL sites, I am getting alot of unknowns from the DNS servers on your dns name. I am not sure what is going on. -- swieduwi ------------------------------------------------------------------------ swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962 View this thread: http://www.excelforum.com/showthread...hreadid=378091 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data in sheet1 to be put into sheets 2, 3, 4, 5, etc | Excel Discussion (Misc queries) | |||
VBA Code Required for deleting All Sheets except Sheet1 | Excel Discussion (Misc queries) | |||
Can I email unique worksheets from a workbook to different users? | Excel Discussion (Misc queries) | |||
How do I set up a workbook so changing Sheet1 changes all sheets? | Excel Worksheet Functions | |||
copy sheet1 and name sheets using names from a range | Excel Programming |