GMA said:
How can I send an email using Access? I tried the Office tab to change to a
word or excel and it sets it up in unusable ways. I cannot copy and paste to
these types of files either. Is there a way to add a tab to send the document
as is via email, OLExpess, Hotmail, Comcast etc.
It'll take a bit of digging to find an appropriate option.
Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm
To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at
http://www.granite.ab.ca/access/email/formatted.htm.
If you want to send multiple emails from a query or table you will
need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separator character, such as comma or
semi-colon, and then send one email with
all the bcc addresses;
2) individually send the emails.
Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.
For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm
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