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 / March 2007

Tip: Looking for answers? Try searching our database.

capturing data FROM a merge document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
andersond@ubinc.com - 13 Mar 2007 20:27 GMT
I am emailing an HTML document to people who attended a seminar we put
on last week.  I am using WORD with data from an EXCEL spreadsheet as
the merge source.  The merge field I am interested in is called
"EMAIL" and, to no one's surprise, is the recipient's email address.
On this HTML document I have a hyperlink that sends the recpient to an
HTML form located on our website where they are asked to complete a
five question survey.  I will have no problem capturing their
responses; however, I also want to capture the email address of those
who reply.

How can I capture the email address that has been merged into the
original HTML document?
ChrisHarrington - 14 Mar 2007 04:20 GMT
Just add the email as the querystring at the end of the url you generate
into the Word document. And have whatever script the url resolves to copy
the email from the url into a form field.

>I am emailing an HTML document to people who attended a seminar we put
> on last week.  I am using WORD with data from an EXCEL spreadsheet as
[quoted text clipped - 8 lines]
> How can I capture the email address that has been merged into the
> original HTML document?
andersond@ubinc.com - 14 Mar 2007 13:37 GMT
On Mar 13, 11:20 pm, "ChrisHarrington" <charrington-at-
activeinterface.com> wrote:
> Just add the email as the querystring at the end of the url you generate
> into the Word document. And have whatever script the url resolves to copy
[quoted text clipped - 18 lines]
>
> - Show quoted text -

I suppose I should have asked for the format for referencing the merge
field.  I have tried {MAILMERGE email}, <<EMAIL>>, etc. and I always
get that string rather than the value.  How do I reference the merge
field?
Peter Jamieson - 14 Mar 2007 14:55 GMT
{ MERGEFIELD email }

The {} have to be the special field code braces you can insert using ctrl-F9

Peter Jamieson
> On Mar 13, 11:20 pm, "ChrisHarrington" <charrington-at-
> activeinterface.com> wrote:
[quoted text clipped - 25 lines]
> get that string rather than the value.  How do I reference the merge
> field?

Rate this thread:






 
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.