电邮TO：处理空白字段 [英] Email TO: Handling Blank Fields

问题描述

当我点击按钮时，我有一段代码可以创建我的电子邮件的TO部分。唯一的问题是它可以从3个不同的领域拉出来。对于一些客户，我只有一个电子邮件地址，但对于其他客户，我可以填写所有3个。当我只用一个电子邮件地址打一个时，我的代码就会停止。如何才能忽略空白电子邮件字段？


这是我正在使用的内容。

I have a piece of Code that creates my TO portion of my email when I hit a button. The only problem is it can pull from 3 different fields. For some clients I have only one email address but for others I could have all 3 filled in. When I hit one with only one email address my code stops. How can I get it to just ignore the blank email fields?

Here is what I am using.

展开 | 选择 | Wrap | 行号

推荐答案

考虑到这是关闭袖口，但应该工作。虽然我不知道你打算如何实现这个，但是Dlookup功能确实可以减慢速度，我通常会尽量避免使用它。也许您可以打开查询然后检查它以查看值是什么以及它们是否存在。当你想要检查一个字段时，这会更快但类似。让我们知道它是怎么回事。

Take into account this is off the cuff but should work. Although I don''t know how you intend on implementing this the Dlookup function sure can slow things down I usually try to avoid using it whenever possible. Maybe you can open a query then check it to see what the values are and if they exist. that would be much quicker but similar for when you want to check a field. Let us know how it goes.

展开 | 选择 | Wrap | 行号

我仍然收到消息未知邮件收件人（s） ）消息没有发送。


谢谢。

I still get the message "Unknown message recipient(s) the message was not sent.

Thanks though.

您可能存储空字符串而不是null。试试这个...

You may be storing an empty string rather than null. Try this ...

展开 | 选择 | Wrap | 行号

这篇关于电邮TO：处理空白字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！