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 [email protected] it is now trying
to find [email protected]#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 [email protected] it is now trying
to find [email protected]#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()

Where NewEmail is an alias for the new column and Email is the fieldname in
your table. The actual SQL, should you ever look at it will be something
like:

Select CStr([Email]) As NewEmail From YourTable;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


[QUOTE="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

[QUOTE="Arvin Meyer"]
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


[QUOTE="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 [email protected] it is now
trying
to find [email protected]#mailto:[email protected]. How do I
ge
trid of what it has added itself!?[/QUOTE]
[/QUOTE][/QUOTE]

 

[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()

Where NewEmail is an alias for the new column and Email is the fieldname in
your table. The actual SQL, should you ever look at it will be something
like:

Select CStr([Email]) As NewEmail From YourTable;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


[QUOTE="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

[QUOTE="Arvin Meyer"]
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 [email protected] it is now
trying
to find [email protected]#mailto:[email protected]. How do I
ge
trid of what it has added itself!?
[/QUOTE][/QUOTE]
[/QUOTE]

 

[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()

Where NewEmail is an alias for the new column and Email is the fieldname
in
your table. The actual SQL, should you ever look at it will be something
like:

Select CStr([Email]) As NewEmail From YourTable;
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


[QUOTE="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 [email protected] it is now
trying
to find [email protected]#mailto:[email protected]. How do
I
ge
trid of what it has added itself!?
[/QUOTE]
[/QUOTE][/QUOTE]