Do you still have the full function? I'm not familiar with this
function
Thanks
--- In [email protected], "steelejohn-gayla"
<[EMAIL PROTECTED]> wrote:
>
> 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: [email protected]
> 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]
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/AccessVBACentral/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
