Send eMail button from datasheet view form

I am quite new to this and my VB knowledge is close to zero.
I have created a for that shows info about applications and it includes a subform with all the people responsible for the application. There are 3 fields shown :
name , tel , email
I want create a button that send an email to selected record.
email field is plain text field that holds the email. I managed to get it working in contacts form which is a single form by adding code :
FollowHyperlink "mailto:"
yet this does not seem to work on the subform in datasheet view.

If anyone understands this please help me out here...

btw i am using Access 2000

Sep 25 '07 #1

Subscribe Post Reply

2843

cyberdwarf

218

Expert 100+

JAT

Have you tried using DoCmd.SendObject ?

Steve

Sep 25 '07 #2

HyBry

Nope
haven't tried that one Steve... As I am new to this I have never came across it before and have no idea what it does.
I actually found out that I had a error in my original code.

Expand|Select|Wrap|Line Numbers

FollowHyperlink "mailto:" & Form!list_1_subform3![E-Mail]

instead of Form!.. I had Forms!.. and that caused it not to work. Took me long time to notice that.
Next step for me is to be able to send mail to all selected people because now on multiple selection it just takes the mail from first selected record?
Any ideas on how it could be done?

Sep 25 '07 #3

Similar topics

Field Names in Datasheet View - A97

by: Keith Wilby | last post by:

I have a form which allows both form and datasheet views. My question is, is it possible to control the field (column) names in datasheet view? What happens at the moment is that the name is...

Microsoft Access / VBA

combo box name property in datasheet view issue

by: Kent Eilers | last post by:

I want to follow naming conventions for my controls - i usually prefix combo boxes with "cbo". When a form is in datasheet view however i do not want the user to see the 'cbo' prefix in front of...

Microsoft Access / VBA

Table <> form in datasheet view

by: Georges Heinesch | last post by:

Hi: I have a tables in relationship to each other. When I open the main table (table 1), I see a "+" at the very left of every record. Clicking on the "+" expands the data of the linked table...

Microsoft Access / VBA

List Box Selection opens in datasheet view

by: Yuki | last post by:

I am trying to find out if I can have a specific record that has been selected in a list box be opened in datasheet view. I can't seem to find where this can happen or what I need to use to make...

Microsoft Access / VBA

Continuous form button captions....

by: David | last post by:

Hi, I need a button shown for each record (cont. form) with specific captions on each. I have a notes form for each record. When a user presses the button they can read the notes. I want to...

Microsoft Access / VBA

visible flag: datasheet versus form view

by: sasan3 | last post by:

when I set visible=false, then entry is not visible in form view, but still shows up in datasheet view. How do I make a field not to show based on some condition in datasheet view? Tx.

Microsoft Access / VBA

Send Mail to Multiple Recipients Form Datasheet View

by: HyBry | last post by:

I have send mail button assigned to datasheet in subform. Works fine if I want to send mail to one person, but I want it to work if I have multiple selection as well. code I have now is ...

Microsoft Access / VBA

Restore size Datasheet View Form on top of Maximized Form

by: Alan Forsyth | last post by:

That rather long subject says it. In Access97 running on XP - I want to display a Maximized size Form01, then open a Restore size Datasheet View Form02 on top of the first Form. PopUp won't give...

Microsoft Access / VBA

Form view changes on Back button from is hyperlink field

by: soulerrant | last post by:

Access 2003 SP2, Win XP I have a form that has Default View = Datasheet; allow Form View = No. Form opens in Datasheet view. The form has a text field with 'Is Hyperlink' set to Yes. When the...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++