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?

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?

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?

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 -

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?

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?