Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2004

Tip: Looking for answers? Try searching our database.

e-mail field in merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer - 17 Feb 2004 04:36 GMT
Any help would be appreciated....I have set up a simple
mail merge with Access.  I have a field for an e-mail
address; there is only one field in the mail merge
template and only one field in the query (f  rom where
I'm extracting the data) but the e-mail address is
published twice.  It seems very odd as all the other mail
merge fields publish just once.....I must be doing
something really stupid!
Peter Jamieson - 17 Feb 2004 06:08 GMT
Are you seeing something like

a@b.com#http://a@b.com

in your merge results?

If so, I would guess that your e-mail address is stored in a hyperlink field
in Access, in which case you will either need to store it using an ordinary
text field, or change your query so that it extracts the text in the
hyperlink field before the # (you can do this by altering the SQL in your
Access query, but first let's establish what is going wrong).

If not, can you describe exactly what your merge field contains and exactly
what result you are seeing (e.g. do you literally see the e-mail address
repeated, or is there space between the two copies, etc.) Also, it would be
useful to know which version of Word/Access you are using.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Any help would be appreciated....I have set up a simple
> mail merge with Access.  I have a field for an e-mail
[quoted text clipped - 4 lines]
> merge fields publish just once.....I must be doing
> something really stupid!
Jennifer - 17 Feb 2004 07:52 GMT
Thank you sooooooooooooooooo much...you were a great help!
>-----Original Message-----
>Are you seeing something like
[quoted text clipped - 28 lines]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.