Send email ?

[JT]

I have 200 records in my table (ContactName, ShippedDate and ContactEmail
columns) and I have one report Letter.
Base on my records I need to send 200 emails separately with attached report
(in pdf format) and send “TO:†would be whatever in my ContactEmail column.
I know how to send one at the time. How to send 200 emails without clicking
200 times to send button?

DoCmd.SendObject acReport, stDocName, acFormatSNP, strTo, strCC, ,
strSubject, strMsg, True
When I set from True to False. I don’t see any more MS Outlook everytime I
try to send but I get for each email MS Outlook message:

Microsoft Office Outlook ‘A program is trying to send email on your behalf.
Do you want to allow this? If this is unexpected, it may be a virus and you
should choose “Noâ€. ‘

So I need click 200 times ‘Yes’, which is same thing.

How to send 200 emails without clicking 200 times to send button?

 

[Arvin Meyer [MVP]]

I use Steve Arbaugh's Email and PDF class with win2pdf:

http://www.groupacg.com/

http://www.win2pdf.com

 

[Tony Toews [MVP]]

I have 200 records in my table (ContactName, ShippedDate and ContactEmail
columns) and I have one report Letter.
Base on my records I need to send 200 emails separately with attached report
(in pdf format) and send “TO:” would be whatever in my ContactEmail column.
I know how to send one at the time. How to send 200 emails without clicking
200 times to send button?

DoCmd.SendObject acReport, stDocName, acFormatSNP, strTo, strCC, ,
strSubject, strMsg, True

This will create the report in Snapshot format. The best solution for
PDF files is Stephen Lebans solution. A2000ReportToPDF is an Access
2000 database containing a function to convert Reports and Snapshot
files to PDF documents. No PDF Printer driver is required.
http://www.lebans.com/reporttopdf.htm

Microsoft Office Outlook ‘A program is trying to send email on your behalf.
Do you want to allow this? If this is unexpected, it may be a virus and you
should choose “No”. ‘

So I need click 200 times ‘Yes’, which is same thing.

How to send 200 emails without clicking 200 times to send button?

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm
There are two solutions there.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[JT]

How to send 200 emails at once without clicking 200 times to send button?
Please help!!!

 

[Arvin Meyer [MVP]]

Here's some code:

http://www.datastrat.com/Code/MultipleEmail.txt

and you may also need the Outlook Redemption dll:

http://www.dimastr.com/redemption/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com