If you want to send out all the addresses on one email, there is a quick and
dirty method that I sometimes use. It's not high-tech as you will see!
First I create a query that gathers up all the email addresses.
Then I export the data in the query as a RTF file to the desktop.
Next I open up the RTF file with Word.
Using Word, I covert the table into text.
Next in Word I replace all the paragraph returns ( ^p ) with semi-colons ( ;
).
I then paste the results into the email address. Usually I put them in the
BCC file to protect the privacy of others.
It sounds like a lot of work, however, it can be automated somewhat. For
example if you export the same email addresses frequently, create a query and
save it. For example I have a query to grab all the email addresses called
qryEmails:
SELECT [Employee Addresses].[E-Mail]
FROM [Employee Addresses]
WHERE ((([Employee Addresses].[E-Mail]) Is Not Null))
ORDER BY [Employee Addresses].[E-Mail];
Then using code or a macro, export the data. That way you could put a button
on a switchboard. Something like this for the code:
DoCmd.OutputTo acQuery, "qryEmails", "RichTextFormat(*.rtf)", "C:\Documents
and Settings\Jerome.Whittle\Desktop\emails.doc", True, "", 0
The above will open the document in Word. While in Word record a macro while
converting the table to text and removing the paragraph markers. Then save
the macro and put a button on your toolbar to run it.
Then it becomes just a matter of clicking a button in Access, then clicking
another button in Word, then doing a copy and past into an Outlook email.
