Hi,

I'm trying to send an email merging one document (docx) with a contacts database (via OleDB). Using MSWord2007, it seems easy (it works for easy things: name, address, ...) but I can't find how fill an query-get url string with a merge field inside an hyperlink.

An hyperlink like: Click here

• where here is an hyperlink to http://domain.com/[email protected]
  • where [email protected] is the address of the contact, a merge field.

I've tried the special/merge fields:

{HYPERLINK "http://domain.com/test.php?contact={MERGEFIELD contactEmail}" \o "Here"}

but it doesn't work, sometimes it merge only the first record and then send all the mails with the same address, I got this alternating the view with ALT+F9.

This support doc doesn't work for me because I don't have the complete URL in my database for each contact, and I can't change the design of the table or add a view (it's from the CRM), I don't like to do it exporting the table and adding the field.

Any idea?

Thanks in advance,