Email address in mailmerge using access

  • Thread starter Thread starter Phippsy
  • Start date Start date
P

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!?
 
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.
 
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

Arvin Meyer said:
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


Phippsy said:
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!?
Click to expand...
Click to expand...
 
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)
 
Not sure how it works but thanks

Arvin Meyer said:
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)
Click to expand...
 
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


Phippsy said:
Not sure how it works but thanks

Arvin Meyer said:
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)
Click to expand...
Click to expand...
 
Back
Top