I have created a database in Access 2000 to store fax and/or e-mail correspondances primarily give each item of correspondance a
unique identity via an autonumber, I also want to e-mail the text of correspondance to the contact selected. The main form stores
the contact details ie e-mail address, name, tele no, etc and its subform stores the details and unique number of each
correspondance.

I have created a control button called cmdSendMail which will bring up the outlook 2000 e-mail form with the contact's e-mail
address in the To: field, taken from the its field on the main form. The code to do this is:

Me.cmdSendMail.HyperlinkAddress = "mailto:" + Me.Form.Email, 

however I cannot get the Subject: or other fields to extract the appropriate information from the different fields of the forms. Do
you have any ideas to help?

If I use the code DoCmd sendObject I can ensure the To: Subject: & cc: fields are filled in when the outlook e-mail form is
called, but this limits the the main form to a single contact and the sub form to storing the correspondance relative to this single
contact.

I would appreciate any information on how to solve this problem.



Many Thanks

Bob 

Have u tried...

Application.FollowHyperlink "mailto:" & [To] & "?cc="
& [CC] & "&subject=" & [Subject]

Change the name of the controls [To], [CC] & [Subject]
accordingly...

HTH
Rajesh

--- rob <rob@r...> wrote:
>  
> I have created a database in Access 2000 to store
> fax and/or e-mail correspondances primarily give
> each item of correspondance a unique identity via an
> autonumber, I also want to e-mail the text of
> correspondance to the contact selected. The main
> form stores the contact details ie e-mail address,
> name, tele no, etc and its subform stores the
> details and unique number of each correspondance.
> 
> I have created a control button called cmdSendMail
> which will bring up the outlook 2000 e-mail form
> with the contact's e-mail address in the To: field,
> taken from the its field on the main form. The code
> to do this is:
> 
> Me.cmdSendMail.HyperlinkAddress = "mailto:" +
> Me.Form.Email, 
> 
> however I cannot get the Subject: or other fields to
> extract the appropriate information from the
> different fields of the forms. Do you have any ideas
> to help?
> 
> If I use the code DoCmd sendObject I can ensure the
> To: Subject: & cc: fields are filled in when the
> outlook e-mail form is called, but this limits the
> the main form to a single contact and the sub form
> to storing the correspondance relative to this
> single contact.
> 
> I would appreciate any information on how to solve
> this problem.
> 
> 
> 
> Many Thanks
> 
> Bob 

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com