Send email ? JT 11/14/2008 2:41:42 AM 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?

Re: Send email ? "Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 11/14/2008 4:53:03 AM I use Steve Arbaugh's Email and PDF class with win2pdf: http://www.groupacg.com/ http://www.win2pdf.com -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "JT" <JT[ at ]discussions.microsoft.com> wrote in message news:A2AEA87B-18D6-478E-BD36-CB05D3F76332[ at ]microsoft.com... [Quoted Text] >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? >

Re: Send email ? "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 11/14/2008 6:43:33 AM JT <JT[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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/

Re: Send email ? JT 11/20/2008 2:42:01 AM How to send 200 emails at once without clicking 200 times to send button? Please help!!! "Tony Toews [MVP]" wrote: [Quoted Text] > JT <JT[ at ]discussions.microsoft.com> wrote: > > >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/ >

Re: Send email ? "Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 11/21/2008 7:00:02 PM 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 "JT" <JT[ at ]discussions.microsoft.com> wrote in message news:22F67B79-579B-4A25-A3F9-B5F02A6558EB[ at ]microsoft.com... [Quoted Text] > How to send 200 emails at once without clicking 200 times to send button? > Please help!!! > > "Tony Toews [MVP]" wrote: > >> JT <JT[ at ]discussions.microsoft.com> wrote: >> >> >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/ >>