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?

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

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

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

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" <(E-Mail Removed)> wrote in message news:B19D0975-FCE8-4CEA-AD03-(E-Mail Removed)...
> 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 <sappe...@discussions.microsoft.com>
>> 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?
>>
>>

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" <(E-Mail Removed)> wrote in message news:B19D0975-FCE8-4CEA-AD03-(E-Mail Removed)...
> > 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 <sappe...@discussions.microsoft.com>
> >> 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?
> >>
> >>
>