Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
Hi
I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
You might check Ron de Bruin's site for something.
http://www.rondebruin.nl/sendmail.htm Otherwise it would have to be custom made. What version of Office do you have? Do you have Outlook? --JP On Mar 27, 7:31*pm, sapper18 wrote: Hi I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
Hi JP - theres a macro on Ron deBruins site that would do half of the job -
e-mail specified files as attachments to a list of recipients, so the only missing step is creating individual files called [clientcode].xls for each client mentioned in the main spreadsheet.... I couldn't find anything else that might work.... "JP" wrote: You might check Ron de Bruin's site for something. http://www.rondebruin.nl/sendmail.htm Otherwise it would have to be custom made. What version of Office do you have? Do you have Outlook? --JP On Mar 27, 7:31 pm, sapper18 wrote: Hi I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
You would probably need two separate routines -- one to do the
filtering based on the client code, the other to email out the workbook to the appropriate email address. Can you post some sample data? Thx, --JP On Mar 28, 8:58*am, sapper18 wrote: Hi JP - theres a macro on Ron deBruins site that would do half of the job - e-mail *specified files as attachments to a list of recipients, so the only missing step is creating individual files called [clientcode].xls for each client mentioned in the main spreadsheet.... I couldn't find anything else that might work.... "JP" wrote: You might check Ron de Bruin's site for something. http://www.rondebruin.nl/sendmail.htm Otherwise it would have to be custom made. What version of Office do you have? Do you have Outlook? --JP On Mar 27, 7:31 pm, sapper18 wrote: Hi I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this?- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
Hi
See http://www.rondebruin.nl/copy5.htm#workbook Hi For body mailing see http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "sapper18" wrote in message ... Hi JP - theres a macro on Ron deBruins site that would do half of the job - e-mail specified files as attachments to a list of recipients, so the only missing step is creating individual files called [clientcode].xls for each client mentioned in the main spreadsheet.... I couldn't find anything else that might work.... "JP" wrote: You might check Ron de Bruin's site for something. http://www.rondebruin.nl/sendmail.htm Otherwise it would have to be custom made. What version of Office do you have? Do you have Outlook? --JP On Mar 27, 7:31 pm, sapper18 wrote: Hi I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create mutiple mails w/ .xls attachments from one spreadsheet
Great - thanks a million JP and Ron - I'll try this out tonight!
"Ron de Bruin" wrote: Hi See http://www.rondebruin.nl/copy5.htm#workbook Hi For body mailing see http://www.rondebruin.nl/mail/folder3/row2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "sapper18" wrote in message ... Hi JP - theres a macro on Ron deBruins site that would do half of the job - e-mail specified files as attachments to a list of recipients, so the only missing step is creating individual files called [clientcode].xls for each client mentioned in the main spreadsheet.... I couldn't find anything else that might work.... "JP" wrote: You might check Ron de Bruin's site for something. http://www.rondebruin.nl/sendmail.htm Otherwise it would have to be custom made. What version of Office do you have? Do you have Outlook? --JP On Mar 27, 7:31 pm, sapper18 wrote: Hi I have a spreadsheet (exported from MS Access) which contains the following info in each column; Column A: Client Name Column B: Client Code Column C: Client E-mail address Column D-Z: Information for clients I want to be able to create an e-mail for each client with an attachment clientcode.xls containing all the info in all the rows containing that client code, sent to the client e-mail address mentioned (the attachment would include columns A-Z). Is there a macro that might do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running mutiple excel sheets on mutiple computers | Excel Discussion (Misc queries) | |||
send e-mails | Excel Discussion (Misc queries) | |||
need help mutiple worksheets to create monthly report sheet | Excel Worksheet Functions | |||
Create a Command Button to Send E-Mails to selected recipients | Excel Worksheet Functions | |||
e-mails addresses | Excel Worksheet Functions |