Create mutiple mails w/ .xls attachments from one spreadsheet

[sapper18]

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?

 

[JP]

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

 

[sapper18]

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]

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

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....

You might check Ron de Bruin's site for something.

Otherwise it would have to be custom made. What version of Office do
you have? Do you have Outlook?

- Show quoted text -

 

[Ron de Bruin]

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

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....

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

 

[sapper18]

Great - thanks a million JP and Ron - I'll try this out tonight!

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

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....

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 <[email protected]>
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?