Emails

[Chi]

Hi,

I use the code that from Daniel Pineault's answer for another user since I
think that it fit to my case.

Application.FollowHyperlink "mailto://" & Me.EmailControlName.

Where EmailControlName is the name of the control on my form that contains a
valid e-mail address to use as the TO: field in the e-mail message.

It works fine with one address like (e-mail address removed). Would you please help
me if I want to sent email to two persons at once.

I tried to add " (e-mail address removed), (e-mail address removed)" on the one row. It
gave me the error message " The field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less data"

Please help
Thank you
Chi

 

[Michel Walsh]

Your field is probably limited to less characters than there is in the
string. In table DESIGN view, increases the maximum number of characters for
that field to 255 (which is the maximum).

Vanderghast, Access MVP

 

[Chi]

Hi Michel,

Thank you so much!! It works perfectly.

 

[Chi]

Hi Michel,

Again, thank you so much for your help! I can send email to both persons at
once by increasing the maximum number of characters and using the code
below!!!

Application.FollowHyperlink "mailto://" & Me.EmailControlName.

Would you please show me how I can add “Project 1" in the subject line of
the email as well as the message " Thank you so much" at the body of the
email?

Please help

Thank you very much!
Chi

 

[Michel Walsh]

I don't know if it is possible with FollowHyperlink to add the subject.

Vanderghast, Access MVP

 

[Chi]

Thank you for your inputs.

Chi

I don't know if it is possible with FollowHyperlink to add the subject.

Vanderghast, Access MVP