Word/发布者电子邮件合并问题 [英] Word/Publisher email merge issues
问题描述
我一直在寻找有关此问题的答案的几天.我试图将访问字段附加到基本URL，以自定义合并中的每封电子邮件，如下所示:
I've been searching for days for an answer to this issue. I'm trying to append an Access field to a base URL to customize each email in my merge like so: http://www.example.com/myItems.asp?ItemID={field}.
我在Word 2007中尝试了几种方法，然后放弃并最终在遇到这篇文章后尝试使用Publisher-
I tried several approaches in Word 2007, then gave up and finally tried Publisher after coming across this post - MS Word: Mailmerge hyperlinks with query get URL string with a MERGEFIELD.
在Publisher中，我可以正确合并所有内容，包括自定义链接(根据预览)，但是当我单击发送电子邮件"时，它没有将电子邮件传递给Outlook-已发送0条消息.我再次尝试，使用空白的电子邮件模板并让其通过电子邮件，但是电子邮件显示的是字段名而不是合并的数据.
In Publisher, I got everything to merge properly including the custom links (according to preview), but when I hit "send email" it wasn't passing the emails to Outlook - said 0 message(s) sent. I tried again, using a blank email template and got it to pass the email, but the email showed field names rather than the merged data.
在本文中浏览有关字段名称的内容- http://msgroups.net/microsoft.public.publisher/emailmerge-not-working-in-publishe/213664 -在发送电子邮件之前，我如建议的那样在文本框外单击，但是仍然显示字段名称，而不显示合并的数据.
Coming across this article regarding the field names - http://msgroups.net/microsoft.public.publisher/emailmerge-not-working-in-publishe/213664 - I clicked outside the text box as suggested before sending email but still, the field names show and not the merged data.
我非常沮丧和精疲力尽.这不应该那么困难！任何想法或建议，将不胜感激.
I'm super frustrated and exhausted. This shouldn't be this difficult! Any ideas or suggestions would be appreciated.
推荐答案
这不应该那么困难！
This shouldn't be this difficult!
I agree. I can't help on the Publisher front, but this link should help for Windows Word.
总而言之，当您插入HYPERLINK字段时，请按照以下方式进行操作:
To summarise, when you insert the HYPERLINK field, do it this way:
- 使用ctrl-F9插入域代码括号对{}
- 在括号之间键入HYPERLINK
- 选择该字段并对其进行一次更新(F9)
不要再次更新此域代码.如果这样做，Word将始终插入相同的链接文本(即超链接目标).从事现场工作的人们经常选择F9只是为了确保一切都是最新的，因此您必须尝试不这样做.
Do not update this field code again. If you do, Word will always insert the same link text (i.e. the hyperlink target). People working with fields often select F9 quite a lot just to make sure things are up to date, so you have to try not to do that.
如果您使用Alt-F9，则应该看到显示文本是一条错误消息(在Word的英语版本中以"E"开头).
If you Alt-F9, you should see that the display text is an error message (starting with "E" in the ENglish language version of Word).
移动插入点，使其紧接在E后面.键入所需的显示文本，或者，如果要使用文本+ MERGE字段等构建的可变显示文本，请输入该文本和这些代码.
Move the insertion point so it is immediately after the E. Type the display text that you want, or, if you want a variable display text built from text + MERGE fields etc, enter that text and those codes).
仔细删除错误文本中的"E"和其他部分.
Carefully remove the "E" and the other part of the error text.
再次使用ALt-F9显示HYPERLINK域代码.在K后面单击，键入一个空格，然后输入以下字段和文本，并假设您的变量文本来自名为fieldname的MERGE字段:
Use ALt-F9 again to display the HYPERLINK field code. Click after the K, type a space, then enter the following fields and text, assuming your variable text is coming from a MERGE field called fieldname:
"{SET X 1} http://www.example.com/myitems. asp?ItemID = {MERGEFIELD字段名}"
"{ SET X 1 }http://www.example.com/myitems.asp?ItemID={ MERGEFIELD fieldname }"
(在SET字段中可以阻止Word做其他事情.如果您有多个HYPERLINK字段，则需要在每个HYPERLINK中设置一个不同的变量名(X1，X2等).这将在
(The SET field is there to stop Word doing something else wrong. If you have more than one HYPERLINK field, you will need to SET a different variable name (X1, X2 etc.) in each HYPERLINK). This is discussed in more detail here - interestingly enough, that question was also about merge to HTML email, but I think you also have to do the additional stuff I mention above to make it all work.
这篇关于Word/发布者电子邮件合并问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
