View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default 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?