Re: Send an e-mail from my contacts form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Ok that didn't work unless I am typing it in the wrong place.
I went to edit hyperlink and in the address where it read http:// I changed
it to MailTo://
However when I went back to the form and typed in an e-mail address the
address showed up in the form as MailTo:w.a.delaney@xxxxxxxxxxx but I still
got the error message. I opened the edit hyperlink and the address at the
bottom of the window changed back to http://w.a.delaney@xxxxxxxxxxx

Is there someplace else I am suppose to enter that. I followed your
instructions from a previous response.
--
BillD


"Pete D." wrote:

Change your code to MailTo:// Let me know on that.
"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A2D2840C-745A-456E-9A57-C78BB7423668@xxxxxxxxxxxxxxxx
Hi Pete,
Entered the code you told me to in the form field
Private Sub CoEmail_AfterUpdate()
CoEMail = "MailTo:"; & CoEMail
End Sub

I then entered an e-mail address that appeared in the form and table as
MailTo:w.a.delaney.1@xxxxxxxxxxx
When I moved out of the field and then back and clicked on it I got the
error message "Cannot Find '(null)'. Make sure the path or internet
address
is correct.
I also closed out the entire database and reopened it and when I clicked
on
the address I got the same error message.

Followed your directions and went into edit hyperlink with the following
results showing:

Top Line Text to Display: Mailto:w.a.delaney.1@xxxxxxxxxxx
Bottom Line Address: http://w.a.delaney.1@xxxxxxxxxxx

I don't know if this is related but I have a filter problem that I can't
get
rid of no matter what I do. When I delete and save the form or database
and
then reopen it the filter comes back on it's own. The filter reads:
(((tblcontacts.LastName IS Null))) AND ((tblcontacts.LastName IS NUll))
I have been trying to get some help on this one also but so far no one has
been able to figure out why the filter keeps coming back. When the filter
is
on I do not see the first record in the table contacts and none of the
command buttons work. When I go to Records and click on Remove filter
everything works fine. Just thought I would see if that could be part of
the
problem since the error message reads "Cannot Find '(Null)'
Thanks

--
BillD


"Pete D." wrote:

One quick test, put code back and test it (I know it might fail, just
want
same error before next step). Then right click hyperlink field and
select
edit hyperlink and see what it says. Top item is what is displayed,
bottom
line is what the link actually is. If you can tell me what it is maybe I
can fix the hyperlink. Pete
"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BF8E1A8-492A-4416-BB83-4EDB6A0790D9@xxxxxxxxxxxxxxxx
I tried it both ways. Once I tabbed to another field and then clicked on
the
e-mail and got the error messages. I then tried it by entering the
e-mail
and
going to another record when I went back and clicked on the e-mail I
got
the
error message again.
I then went in and deleted the function code that you had me enter and
when
I would type in the email address I could click on it and it would open
the
email with the address filled in.
If code would work that would be great All I would need from you is the
code
written out and where in the event I should put it (i.e. after update)
My
e-mail is Microsoft Outlook 2003
Thanks Pete
--
BillD


"Pete D." wrote:

I was afraid you might have a problem as hyperlink address isn't the
best
way to do it. Did you change records and go back or after tabbing out
go
back and click the hyperlink. Would you be intrested in some VBA to
make
it
more dependable? What email program do you use?

"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AD38918A-CB70-4C4D-BD4B-B0F74A256790@xxxxxxxxxxxxxxxx
Entered the code like you said. When I type in the e-mail address it
shows
up
as Mailto:email address. However when I click on the e-mail address
in
the
form I get the following Cannot Find '(null)'. Make Sure the path or
internet
address is correct. I know it is correct because I used my own email
address
then when I typed in another address it opened a web site.
Here is a copy paste of the code I entered

-- Private Sub CoEMail_AfterUpdate()
CoEMail = "Mailto:"; & CoEMail

End Sub
BillD


"Pete D." wrote:

Okay, put form in design view, select field and open properties.
Select
after update and then the ... button. It will give you a vba
window.
My
field is EmailName so use your field name. See below to have it
fix
your
problem. Pete

Private Sub EmailName_AfterUpdate()
EmailName = "mailto:"; & EmailName
End Sub

"Pete D." <pduffy211AT@xxxxxxxxxx> wrote in message
news:eJ5nk.15655$1N1.14824@xxxxxxxxxxxxxxx
Yes it is possible, give me a bit to review. Pete
"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7D2567C-4B84-4817-80C1-3F5CADDFB16A@xxxxxxxxxxxxxxxx
Ok I added mailto: to three address and then clicked on them and
the
mail
opened just fine.

So where to from here. Is it possible to have mailto populated
automatically
or do I just enter that each time

Thanks

--
BillD


"Pete D." wrote:

Just for fun, add mailto: infront of a couple of addresses and
see
if
they
works. Then we can look at the details. I just want to make
sure
we
are
on
the right track. Right click on the field to edit hyperlink.
Pete
"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:785370C0-EC3A-46BB-AD8F-9D11F49E7C75@xxxxxxxxxxxxxxxx
No there is no mailto infront of the address. All it shows on
the
form
and
the table is for example: name@xxxxxxxxxxx or
name@xxxxxxxxxxxxxxx

If I have to have the mailto infront of the address do I have
to
type
that
in everytime or is there a way to have that entered for me
either
in
the
address or behind the scenes. If there is a way could you
kind
of
explain
it
is easy to understand terms as I am still rather new to some
things
in
Access.
Thanks
--
BillD


"Pete D." wrote:

Is the address prefixed with mailto: Sounds like it isn't
seeing
it
as a
email address but a standard web site. 2007 does have a (I
call
it
sticky
filter) but if after converting the file and forms you turn
it
off
and
save
it the form without the filter it goes away. I havn't had
time
to
play
with
this problem or a reason to but someone may jump in and
answer
that
question.

"BillD" <BillD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:102CD07D-E259-4C6E-963E-265769749FD3@xxxxxxxxxxxxxxxx
Hi Pete,
I did as you said and added the field from the contacts
table.
When
I
enter
an e-mail address in the e-mail field it underlines and
changes
to
blue,
however when I click on it to send an e-mail I get either
error
messages
or a
web site for the email server opens. I tried to send one
e-mail
to
a
comcast.net address and got the following message "Cannot
Find
'(null)'.
Make
Sure Path or Internet Address is Correct". Another address
was
to a
Frontiernet.net and when I clicked on the address the
Frontier
web
site
opened.
My Outlook program is open and minimized when I do this if
you
are
wondering.

Would this have anything to do with a filter problem I am
having
that I
cannot remove. When I open my contacts form none of the
fields
populate
and
none of the command buttons work until I go to "Records",
"Remove
Filter"
then everything works fine. I checked the form properties
and
the
filter
field shows (((tblcontacts.LastName Is Null))) AND
((tblcontacts.LastName
Is
Null)) the Data entry field is set to no. In the Advance
Filter/Sort
there
is
Nothing in the filter that is there. I removed the filter
in
the
form
properties but everytime I close and open the form the
filter
data
returns
on
it's own and I have no idea how to get rid of it.

If this could be the problem do you know how I can get rid
of
the
filter,
where I would look to remove what ever is automatically
entering
that
filter
information
--
BillD

.

Quantcast