Trying to create an Internet Email field on Form or Table 
Author Message
 Trying to create an Internet Email field on Form or Table

I noticed I can make a field that is a hyperlink on a table, and then use
that field on a form.  But there is no way that I can see to make a field
that handles an email address, so that I can click on the field and have it
open Word to make an email message.  Just like the hyperlink field type
works.  

If this requires code, could you provide a sample, (I am not much of a
coder).

Thanks...

PeterD

--
++++++++++++++++++++++++++++++++++++++++++++++

Peter DeSimone

++++++++++++++++++++++++++++++++++++++++++++++



Thu, 22 Jul 1999 03:00:00 GMT  
 Trying to create an Internet Email field on Form or Table

Peter,

Our IDSMail OLE Server will let you send/receive E-mail from your Access
application quite easily.  IDSMail works with any E-mail system based on
MAPI, SMTP/POP3, VIM, MHS, or Banyan VINES.

For example, here is all the Access Basic code you would need to send an
Internet E-mail message with a file attachment:

Dim idsMail as Object
Set idsMail = CreateObject("IDSMailInterface.Server")
idsMail.ObjectKey = "ABC123"
idsMail.MailSystem =IDSM_SYS_SMTP_POP
idsMail.SMTPServer = "myprovider.com"  



idsMail.Subject = "Meeting Agenda"
idsMail.AddAttachment "C:\MEETINGS\AGENDA.DOC"
idsMail.Message = "Here is the agenda for the weekly meeting."
idsMail.Send

For more information on IDSMail, go to http://www.intuitive-data.com

--
Regards,

Eric June
Intuitive Data Solutions

--------- We Make OLE Servers Intuitive --------------

Intuitive Data Solutions          
Send/Rcv Email *EASILY* through SMTP/POP, VIM, MAPI, MHS & VINES.
http://www.intuitive-data.com/idsmail.htm
------------------------------------------------------



Fri, 23 Jul 1999 03:00:00 GMT  
 Trying to create an Internet Email field on Form or Table

Hello Peter,

I've done it my making my field of type Hyperlink, and typing:


Seems to work fine here.  BTW, this is the same syntax you would use to
create a hyperlink on a web page.  The mailto: is the way the the HTML
processor reading the HREF argument of the A tag determines that this URL
should be handled by your default mail program.

I hope this helps,

Larry Tubbs, MCPS, MCSD
Silverleaf Vacation Club



Quote:
> I noticed I can make a field that is a hyperlink on a table, and then use
> that field on a form.  But there is no way that I can see to make a field
> that handles an email address, so that I can click on the field and have
it
> open Word to make an email message.  Just like the hyperlink field type
> works.  

> If this requires code, could you provide a sample, (I am not much of a
> coder).

> Thanks...

> PeterD

> --
> ++++++++++++++++++++++++++++++++++++++++++++++

> Peter DeSimone

> ++++++++++++++++++++++++++++++++++++++++++++++



Fri, 23 Jul 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Create new fields in a table based off of fields in another table

2. Create new field in existing table exactly like field in second table

3. Trying to create a VBA script that will send out an email everyday

4. Populate form fields from email Fields

5. Trying to create script to email with OE

6. Create table from a combined field in another table

7. create table query creates strange fields

8. create table query creates strange fields

9. Trying to bind datetimepicker to SQL table datetime field

10. Data Type Conversion error trying to store Pic in Table Field

11. Still trying to create a hidden Access Table

12. still trying to post data to an internet form from VB

 

 
Powered by phpBB® Forum Software