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/
