it works for me in some of my unattended automated processes.
----- Original Message ---- From: mick_curtis <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, November 17, 2006 7:48:33 AM Subject: Re: [Access VBA Central] Export data into a text file - email I tried clickyes and mapilab software. My requirement was that a locked pc should be able to send emails as a scheduled event. I am not sure if ClickYes could handle that. It was a while back. So I can't remeber clearly. Mike --- In AccessVBACentral@ yahoogroups. com, "Dennis Mahoney" <[EMAIL PROTECTED] ..> wrote: > > The issue you describe is mostly likely due to a security setting, not to > Access. For example, in Outlook Express there is a checkbox: > Options/Security/ Warn me when other applications try to send mail as me. > This has fixed the problem for me. > > > > Dennis > > > > > > > > _____ > > From: AccessVBACentral@ yahoogroups. com > [mailto:AccessVBACentral@ yahoogroups. com] On Behalf Of steelejohn- gayla > Sent: Tuesday, November 07, 2006 08:32 PM > To: AccessVBACentral@ yahoogroups. com > Subject: Re: [Access VBA Central] Export data into a text file - email > > > > I have used DoCommand.SentObjec t for what you are describing. I read a table > of recipiants, run a query for their branch, and then use the SendObject > action to email it to them. I have done this with both Excel data and with > Snapshots output of Access reports. When I first set it up, I discovered > that it caused a message to appear that warned me that a program on my > computer was attempting to send something. I had to click "yes" to allow > each message to be sent. This was worked around by downloading a little > program called "ClickYes.exe. " When activated this program simply responds > to the message asking your to clickyes. > > ----- Original Message ----- > From: myhnews > To: AccessVBACentral@ <mailto:AccessVBACe ntral%40yahoogro ups.com> > yahoogroups. com > Sent: Monday, November 06, 2006 9:20 AM > Subject: [Access VBA Central] Export data into a text file - email > > I created a report with about 13 fields. I would like to create a > button that exports the data from that report into a text file. (The > purpose of this report is to send it via email, so if I can create a > button that copies the data right into the email that is even better) > > Does anyone know of any way? > > Thank you > > ------------ --------- --------- --------- --------- --------- - > > > [Non-text portions of this message have been removed] > > > > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
