Email address in mailmerge using access

[Phippsy]

Hi

I am using access 2007 and word 2007 to do an email mailmerge. I have a
field for email address in access with the properties for a hyperlink - i
have tried changing this to a text field with the same result.
I start in Word and use the mailmerge wizard and everything is fine until I
come to complete the merge and it cannot find the addresses because it has
added information after the record enty.
For example if the record entry is (e-mail address removed) it is now trying
to find (e-mail address removed)#mailto:[email protected]. How do I ge
trid of what it has added itself!?

 

[Arvin Meyer [MVP]]

The protocol is actually using:

mailto:someone@somewhere

so if you want to pass it you will need to change the hyperlink to text,
then try passing it like:

CStr([Me.txtEmail]) so that it is really obvious that it is not a hyperlink.

 

[Phippsy]

I have changed the field to text but no difference andnot sure what you mean
by the rest.

What does > CStr([Me.txtEmail]) mean and where do I put this.
Thanks

The protocol is actually using:

mailto:someone@somewhere

so if you want to pass it you will need to change the hyperlink to text,
then try passing it like:

CStr([Me.txtEmail]) so that it is really obvious that it is not a hyperlink.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi

I am using access 2007 and word 2007 to do an email mailmerge. I have a
field for email address in access with the properties for a hyperlink - i
have tried changing this to a text field with the same result.
I start in Word and use the mailmerge wizard and everything is fine until
I
come to complete the merge and it cannot find the addresses because it has
added information after the record enty.
For example if the record entry is (e-mail address removed) it is now trying
to find (e-mail address removed)#mailto:[email protected]. How do I ge
trid of what it has added itself!?

 

[Arvin Meyer [MVP]]

I though you were working from an Access form to Word. If you use a query as
the source for the merge, add a column that looks like:

NewEmail: CStr((e-mail address removed)

 

[Phippsy]

Not sure how it works but thanks

I though you were working from an Access form to Word. If you use a query as
the source for the merge, add a column that looks like:

NewEmail: CStr((e-mail address removed)

 

[Arvin Meyer [MVP]]

If you are having difficulty in understanding how Access works, I suggest
that you watch Crystal's Video tutorials. They are an excellent source for
learning Access:

http://www.accessmvp.com/Strive4Peace/Index.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Not sure how it works but thanks

I though you were working from an Access form to Word. If you use a query
as
the source for the merge, add a column that looks like:

NewEmail: CStr((e-mail address removed)