Currently I am generating invoices in a report which is printed and the 
invoices mailed to the customer. I would like to email the individual 
invoices to the repective customer. I would appreciate any ideas on how to go 
about generating upwards of 5000 invices and emailing them to the individual 
customer. Thank You

Take a look at:
http://www.datastrat.com/Code/MultipleEmail.txt

Steve

santus@penn.com



"Chuck" <Chuck@discussions.microsoft.com> wrote in message 
news:F19CA4A4-B9DA-42AA-AA42-9B1DF9AA4EDD@microsoft.com...
> Currently I am generating invoices in a report which is printed and the
> invoices mailed to the customer. I would like to email the individual
> invoices to the repective customer. I would appreciate any ideas on how to 
> go
> about generating upwards of 5000 invices and emailing them to the 
> individual
> customer. Thank You 

While I wrote the code that you pointed the OP to, I don't think that's what 
he needs. It does not send individual invoices, it would send the same 
invoice to each individual. For multiple invoices to multiple individuals, 
I've send them as PDFs using Steve Arbaugh's PDF and Mail Class:

http://www.groupacg.com/

I believe you can do something similar with FMS's emailer:

http://www.fmsinc.com/Products/Emailer/Access_Emailer_2007.asp
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.

"Steve" <notmyemail@address.com> wrote in message 
news:%236Fzo9SdKHA.5984@TK2MSFTNGP06.phx.gbl...
> Take a look at:
> http://www.datastrat.com/Code/MultipleEmail.txt
>
> Steve
>
> santus@penn.com
>
>
>
> "Chuck" <Chuck@discussions.microsoft.com> wrote in message 
> news:F19CA4A4-B9DA-42AA-AA42-9B1DF9AA4EDD@microsoft.com...
>> Currently I am generating invoices in a report which is printed and the
>> invoices mailed to the customer. I would like to email the individual
>> invoices to the repective customer. I would appreciate any ideas on how 
>> to go
>> about generating upwards of 5000 invices and emailing them to the 
>> individual
>> customer. Thank You
>
> 

Thank you, I have emailed their support to get more details.


"Arvin Meyer [MVP]" wrote:

> While I wrote the code that you pointed the OP to, I don't think that's what 
> he needs. It does not send individual invoices, it would send the same 
> invoice to each individual. For multiple invoices to multiple individuals, 
> I've send them as PDFs using Steve Arbaugh's PDF and Mail Class:
> 
> http://www.groupacg.com/
> 
> I believe you can do something similar with FMS's emailer:
> 
> http://www.fmsinc.com/Products/Emailer/Access_Emailer_2007.asp
> -- 
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
> 
> Disclaimer: Any code or opinions are offered here as is. Some of that
> code has been well tested for number of years. Some of it is untested
> "aircode" typed directly into the post. Some may be code from other
> authors. Some of the products recommended have been purchased and
> used by the author. Others have been furnished by their manufacturers.
> Still others have not been personally tested, but have been
> recommended by others whom this author respects.
> 
> You can thank the FTC of the USA for making this disclaimer necessary.
> 
> "Steve" <notmyemail@address.com> wrote in message 
> news:%236Fzo9SdKHA.5984@TK2MSFTNGP06.phx.gbl...
> > Take a look at:
> > http://www.datastrat.com/Code/MultipleEmail.txt
> >
> > Steve
> >
> > santus@penn.com
> >
> >
> >
> > "Chuck" <Chuck@discussions.microsoft.com> wrote in message 
> > news:F19CA4A4-B9DA-42AA-AA42-9B1DF9AA4EDD@microsoft.com...
> >> Currently I am generating invoices in a report which is printed and the
> >> invoices mailed to the customer. I would like to email the individual
> >> invoices to the repective customer. I would appreciate any ideas on how 
> >> to go
> >> about generating upwards of 5000 invices and emailing them to the 
> >> individual
> >> customer. Thank You
> >
> > 
> 
> 
> .
> 

Chuck <Chuck@discussions.microsoft.com> wrote:

>Currently I am generating invoices in a report which is printed and the 
>invoices mailed to the customer. I would like to email the individual 
>invoices to the repective customer. I would appreciate any ideas on how to go 
>about generating upwards of 5000 invices and emailing them to the individual 
>customer. 

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

For a page on how to print a report for a single record and how to
generate reports to attach to emails see the Emailing reports as
attachments from Microsoft Access page at
http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/