email addresses

[Anne]

I have a database with a list of basketball contacts and now I want to be
able to use their emails and send them newsletters but I am not sure of best
way. I have a basic understanding of access and use it quite a lot but have
not had much experience with using email addresses in it.

I imported an excel file with approximately 600 names and email addresses to
a new access 2003 table. I set the field to hyperlink and would like to make
all entries to show as email addresses rather than as web addresses. I know
I can change each one individually but is there a quicker way to make each
one a email address by setting the field defaults. I would then also like to
add all these addresses to my email program

Any suggestions as to the best approach Thanks

 

[Brett Collings [429338]]

I imported an excel file with approximately 600 names and email addresses to
a new access 2003 table. I set the field to hyperlink and would like to make
all entries to show as email addresses rather than as web addresses.

Any suggestions as to the best approach Thanks

Anne the hyperlink format for email addresses as the ControlSource for
a form control is

="mailto:" & [EmailField]

Since all your forms should be based on a Query, you can created a new
object (column/field) in the Query Design View by calling it..

SendMailTo: "mailto:" & [EmailField]

A new object [SendMailTo] is thus created and can now be used just as
if it were a field from the table.



Cheers,
Brett