Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I send data from excel thru smtp
Here is what I am trying to do: I am looking for a method to automate sending the results of a list out to a set of individual email addresses in an adjacent list. My worksheet has values in A:H G is called from a VLOOKUP list based on the value that is entered in C. So for all rows that contain adjacent matching values (names), in column G, I want to select those rows and copy and paste that information into an email to the person in G. I want suggestions for the best approach to this. I was thinking either a macro, or something 'underneath' the excel worksheet that could accomplish without having to make excel click on an email address and copy and paste data in to separate emails. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I send data from excel thru smtp
Check out my site for examples Bender
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "bender" wrote in message ... Here is what I am trying to do: I am looking for a method to automate sending the results of a list out to a set of individual email addresses in an adjacent list. My worksheet has values in A:H G is called from a VLOOKUP list based on the value that is entered in C. So for all rows that contain adjacent matching values (names), in column G, I want to select those rows and copy and paste that information into an email to the person in G. I want suggestions for the best approach to this. I was thinking either a macro, or something 'underneath' the excel worksheet that could accomplish without having to make excel click on an email address and copy and paste data in to separate emails. Thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
smtp | Setting up and Configuration of Excel | |||
How do I send data to a person or BCC a group in excel? | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
How to send data from Excel to a Database | Excel Programming |