If you'd like to include the people's names, in addition to their e-mail addresses, then create a
query similar to the following:
SELECT [LastName] & " " & [FirstName] & " " & "<" & [EMailAddress] & ">"
AS [Name Last, First & E-Mail Address]
FROM tblMembers
ORDER BY LastName, FirstName;
The SQL statement shown above is valid for a table named "tblMembers", with field names of
FirstName, LastName and EMailAddress. You can substitute the appropriate field and table names
for your database. This query produces output similar to the following;
Lastname Firstname (e-mail address removed)
You can use the "drag & drop" technique to export the results to an Excel spreadsheet.
Alternatively, you can copy the results directly from the query's displayed recordset, and paste
them into a new e-mail message. However, if you do this, you will also get the column heading:
Name Last, First & E-Mail Address, which will not resolve correctly when you click on check
names. The part that I like about this format is that it is very easy to verify at a later date
exactly who you sent a message to, without having to decipher e-mail addresses which might be a
bit cryptic. Note that I did not include a comma in-between the Lastname and the Firstname,
since Outlook Express uses a comma as a valid separator for e-mail addresses. I believe you can
configure Outlook to treat a comma as a valid e-mail address separator or not, but this level of
control is not available in Outlook Express.
Tom
_________________________________________
Right click on the table you need to export, then click on:
Export
You can export to a .CSV file there. Just follow the prompts
along. It's self-explanatory for the most part. If you have a
question about something specific, come back here and let
us know.
;-)
--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.
_________________________________________
I have a list of contacts in Access, with e-mail addresses.
I would like to export those to a text file or stream with just commas
separating the e-mail addresses (i.e. I want to just paste all email
addresses into the "To" line).
Does anyone have a simple function to do this?
Thanks;
Michael
