email addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anne - 07 Nov 2004 14:39 GMT

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

Reply to this Message

Brett Collings [429338] - 12 Nov 2004 09:36 GMT

>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

----------------------------------------------
Be adventurous, be bold, be careful, be a star
----------------------------------------------
Brett Collings
Business & Systems Analyst
Management Information Systems Developer

Reply to this Message