A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

E-mail storage in Access



 
 
Thread Tools Display Modes
  #1  
Old March 14th, 2005, 02:33 PM
TC
external usenet poster
 
Posts: n/a
Default E-mail storage in Access

I have a database that stores contractor information. I would like to set up
a field for their e-mail. I've stored OLE links for websites in the past
that automatically launch the website. I would like to be able to launch
Outlook and have the address appear in the To: field. This works fine in
Excel. How can I do it in Access?
  #2  
Old March 14th, 2005, 03:03 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

Create a text-type field in your contractor info table. In your contractor
info form (you ARE using forms, right?!), put code behind the double-click
event for that field. In that code, you can open/create an email using the
contents of the fields as a 'mailto:' address.

--
Good luck

Jeff Boyce
Access MVP

"TC" wrote in message
...
I have a database that stores contractor information. I would like to set

up
a field for their e-mail. I've stored OLE links for websites in the past
that automatically launch the website. I would like to be able to launch
Outlook and have the address appear in the To: field. This works fine in
Excel. How can I do it in Access?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word mail merge with Access Linda Mailmerge 1 December 7th, 2004 11:46 PM
Word mail merge doesn't pick up the addresses in Access database. Julie Tables 1 November 24th, 2004 01:26 AM
Too Few Parameters error Mail Merge Access Parameter Query Tony_VBACoder Mailmerge 3 September 14th, 2004 12:15 PM
Mail merge to Word from Access 2000 Anthony General Discussion 1 August 4th, 2004 12:35 PM


All times are GMT +1. The time now is 11:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.