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 [email protected], "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: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of steelejohn- gayla > Sent: Tuesday, November 07, 2006 08:32 PM > To: [email protected] > Subject: Re: [Access VBA Central] Export data into a text file - email > > > > I have used DoCommand.SentObject 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:AccessVBACentral%40yahoogroups.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] >
