Create mutiple mails w/ .xls attachments from one spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sapper18 - 28 Mar 2008 00:31 GMT

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 to this Message

JP - 28 Mar 2008 03:20 GMT

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 <sappe...@discussions.microsoft.com>
wrote:

> Hi
>
[quoted text clipped - 12 lines]
>
> Is there a macro that might do this?

Reply to this Message

sapper18 - 28 Mar 2008 13:58 GMT

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.
>
[quoted text clipped - 23 lines]
> >
> > Is there a macro that might do this?

Reply to this Message

JP - 28 Mar 2008 14:22 GMT

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 <sappe...@discussions.microsoft.com>
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
[quoted text clipped - 32 lines]
>
> - Show quoted text -

Reply to this Message

Ron de Bruin - 28 Mar 2008 14:27 GMT

Hi

See
http://www.rondebruin.nl/copy5.htm#workbook

Hi For body mailing see
http://www.rondebruin.nl/mail/folder3/row2.htm

Signature

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
[quoted text clipped - 30 lines]
>> >
>> > Is there a macro that might do this?

Reply to this Message

sapper18 - 28 Mar 2008 18:50 GMT

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

> Hi
>
[quoted text clipped - 38 lines]
> >> >
> >> > Is there a macro that might do this?

Reply to this Message