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?