Using MAILMERGE fields within HYPERLINK fields for Merge to Email



  • 1. Trim text
    HI, I created a MS Word mail merge from an applicaiton (runs on a SQL backend) to print training certificates. The course name in the database contains a code infront of the name i.e. BA10:Novell Networking Foundations. Is there a way to remove the BA10: portion of the course name so that it only displays Novell Networking Foundation. I would rather do that then prompting the users to enter course names with typos... Many thanks in advance Miriam
  • 2. How do I get a picture to email using merge?
    I cannot get a picture included with text to send using email merge. The text is being sent without the picture. I can copy the document into Outlook Express and it mails ok. Just not when I send using email merger.
  • 3. Headers in Merged Tables
    With the help of this group, I was able to set up my WP merge tables in Word. I am, however, having difficulty with the report titles and header rows. In the WP merge document, the header rows and title of the report are entered in the unmerged document . In Word, if I insert the header row and title of the report before the document is merged, it creates a separate table for each record. Can someone provide some insight as to how to have the header rows and title appear only once? Thanks in advance for your help.
  • 4. How can I insert a placeholder for blank Word merge fields?
    How do I tell word to insert placeholder for an empty mergefield instead of leaving it blank? I'm working on a form with merged information and my field alignments are messed up whenever Word comes across a blank field. Thanks.
  • 5. Losing every other record merging word doc. with excel
    I am losing half of the records in excel when a merge into a tabel in word . Someone else posted the same problem and it was suggested to remove the "next record" field. I did and it printed 2, 3 and 4 of the same name. Any other suggestions? Thank you! -- Michelle

Using MAILMERGE fields within HYPERLINK fields for Merge to Email

Postby TWFyayBW » Sat, 04 Dec 2004 15:09:01 GMT

It appears that MAILMERGE fields within HYPERLINK fields are not updated like 
MAILMERGE fields used elsewhere in a mail merge document as the merge is 
being performed.  Is this correct?

For instance, using the statement below within a document for Merge to Email 
should, in theory, insert the value of the PONumber field for each record of 
the data source into the mailto: hyperlink.  If the HYPERLINK field is 
manually updated using F9, the MERGEFIELD value is updated, the PONumber 
value for the current record is incorporated into the hyperlink and the 
hyperlink functions as expected, however, the MERGEFIELD value is not updated 
when the Merge to Email sequences through each record.

"PONumber"}%20Already%20Paid" \o "Click here to send an email if you've 
already paid"}

Is there a way to ensure that the MERGEFIELD within the HYPERLINK statement 
is automatically updated when the Merge to Email sequences through the data 
source records?

Thanks, Mark V

RE: Using MAILMERGE fields within HYPERLINK fields for Merge to Email

Postby TWFyayBW » Sat, 04 Dec 2004 23:59:17 GMT

Sorry, failed to mention below that I'm running Word 2003 (11.5604.5703) and 
Outlook 2003 (11.5608.5703) from Microsoft Office Professional Edition 2003 
on Windows XP Professional, SP1.

Re: Using MAILMERGE fields within HYPERLINK fields for Merge to Email

Postby Cindy M -WordMVP- » Mon, 06 Dec 2004 01:01:59 GMT

Hi =?Utf-8?B?TWFyayBW?=, 

The mail merge field embedded in the Hyperlink field does update. What does NOT 
change is the display text for the Hyperlink field. The only way I've ever found 
to get this to work is:
    - set up the mail merge with everything except the hyperlink and test
    - when you're all set, create the Hyperlink field but do NOT force a manual 
update and do NOT toggle back to field results. Merge directly to a new 
    - Ctrl+A, F9 to update the fields. The display text will be the hyperlink 
path (there's no way to change this)

Now, since you want to send emails, you'll need to pull the result document 
apart and email it, section by section. You'll find macro code for this on by Doug Robbins.

Cindy Meister
INTER-Solutions, Switzerland
 http://www.**--****.com/ (last update Jun 8 2004)

This reply is posted in the Newsgroup; please post any follow question or reply 
in the newsgroup and not by e-mail :-)

Similar Threads:

1.Insert Merge field within a Hyperlink field

I am trying to nest a Mergefield within the Word Hyperlink 
Is this possible?

Thanks in advance for any help

ian do i send a mailmerge email using a merge field as subject

3.Mail Merge - Fields missing within "insert merge field" tab

I have an Excel database, with approx 130 data columns, which I use with mail
merge in word for a variety of documents letters, etc to send to customers.
Until last week, this worked with no problem whatsoever, then last week, I
started getting a message that the "DDE connection could not be re-
established", meaning that I couldn't open my word files.  I've managed to
find the work around for this on Microsoft's site, by choosing the convertor
method of opening the excel file rather than DDE but now find that a lot of
the merge fields don't work.

When I check in the "insert merge field" tab, the first 59 data fields are
listed, the next four appear together as one field and then there is no
mention of the rest.  Can anybody advise please?  I am not very good with
computers, so if any explanations could assume I know nothing and take me
through step by step, that would be great!

I have Windows XP Home SP2 2002 version and am using Word & Excel 97.

Many thanks in anticipation!

4.Missing Date Field in Email Message when merged to electronic mail form Word Mailmerge


When we use Outlook Express normally it sends a date with the message.

When we mail merge to electronic mail from Word it DOES NOT send a
date with the message.

Subsequently a lot of the messages fail to arrive.

We have tried this on four machines, two operating systems W98 and XP.
Three different versions of OE and from three different locations
through three ISP's .It still does it on each.

How can we make sure OE sends a date with the message when used as a
mail merge client with Word. ?

Regards, David

5.Fields within fields that cross-ref to other fields and do not upd

I have a 'parent' document document with several 'children' and the 'parent' 
will eventually be placed in a 'parent' of its own, a 'grandparent' so to 
speak. The problem is that one of the cross-references in the child to a 
caption will not update. 

The caption is formatted as "Figure {Heading1 #}-{Figure #}: text" and no 
Heading1 is available in the child, producing an error:"Figure Error! No text 
of specified style in document." at both the cross-ref and the caption.
When viewed in the parent, the caption updates to display the Heading1 
number it is placed under, but the cross-reference keeps displaying the error.

6. Help on Mailmerge field (field length) - field getting truncated

7. Use Merge Field in Email "To" field

8. Want to Merge WEB CONTENT from merged hyperlink-as-data-field

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 81 guest