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.
{HYPERLINK "mailto: XXXX@XXXXX.COM ?subject=PO%20{MERGEFIELD
"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
Using MAILMERGE fields within HYPERLINK fields for Merge to Email
3 posts
• Page 1 of 1
- Microsoft publisher
- Windows
- php
- hp
- fortran
- VC
- Windows
- MS OFFICE OUTLOOK
- Small Business Accounting
- Exchange 2000
Jump to:
- 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
Next
Using MAILMERGE fields within HYPERLINK fields for Merge to Email
by TWFyayBW » Sat, 04 Dec 2004 15:09:01 GMT
RE: Using MAILMERGE fields within HYPERLINK fields for Merge to Email
by 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
by 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
document.
- 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
word.mvps.org by Doug Robbins.
Cindy Meister
INTER-Solutions, Switzerland
http://www.**--****.com/ (last update Jun 8 2004)
http://www.**--****.com/
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 field. Is this possible? Thanks in advance for any help ian
2.how 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
Hello, 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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 81 guest