MS Word:带查询的Mailmerge超链接获取带有MERGEFIELD的URL字符串 [英] MS Word: Mailmerge hyperlinks with query get URL string with a MERGEFIELD

问题描述

我正尝试发送一封电子邮件(通过OleDB)将一个文档(.docx)与一个联系人数据库合并.使用MS Word 2007似乎很容易(它适用于简单的事情:名称，地址等)，但我找不到如何在超链接中的合并字段中填充查询得到的URLD字符串的方法.

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

超链接，例如:单击此处

• 其中此处是超链接 http://domain.com/test.php?contact=contact@contactdomain. com
  • 其中[e-mail]是 联系人的地址，一个合并字段.
  • where here is an hyperlink to http://domain.com/test.php?contact=[e-mail]
    • where [e-mail] 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"}

    但是它不起作用，有时它仅合并第一条记录，然后发送具有相同地址的所有邮件，我将其与 ALT + F9 交替显示.

    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.

    此支持文档不适用于我，因为我没有完整的文档数据库中每个联系人的URL，并且我无法更改表的设计或添加视图(来自CRM)，我不喜欢导出表并添加字段.

    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.

    有什么主意吗?

    预先感谢

    推荐答案

    好的，我认为MS忘记了MSWord中的某些内容.在MS Publisher 2007中存在此功能(称为个性化超链接")，请参见此处开始邮件合并，然后您可以找到一个使用附加表格进行操作的选项(我在Word中找不到).我不知道Word2010是否具有此选项，但是Publisher 2007对我来说还可以.

    OK, I think that MS forgot something in MSWord. In MS Publisher 2007 exists this functionality (called "Personalized hyperlinks") See at here to begin the mailmerge, then you can find an option to do that with an extra form (I didn't find in Word). I don't know if Word2010 has this option, but Publisher 2007 is OK for me.

    谢谢.

    这篇关于MS Word:带查询的Mailmerge超链接获取带有MERGEFIELD的URL字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！