MeetingItem收件人。(MeetingItem Recipient. How to get email)
我发现了一个类似的问题,但对于C# Outlook:如何从收件人字段获取电子邮件? 在这个问题上,也没有正确的答案。
不过,我尝试了一些来自此主题的答案
recipient.AddressEntry.Address
<=返回与recipient.Address
相同的东西。地址直到现在我还没有使用,并且结果如下:"/o=POST/ou=Zuerich/cn=Recipients/cn=eicherr"
我如何获得收件人的电子邮件地址?
我也尝试
.AddressEntry.GetContact().Email1Address
和.AddressEntry.GetExchangeUser().Address
这一切都不适合我。这里是一个MSDN文件解释如何获得电子邮件地址,但我不知道如何在代码中使用它获取收件人的电子邮件地址
我的代码:
Dim Msg As Outlook.MeetingItem Set Msg = Item Set recips = Msg.Recipients Dim recip As Outlook.Recipient For Each recip In recips Dim email as String email = CStr(recip.Address) Debug.Print email End For
I found a similar question but for c# Outlook : How to get email from Recipient field? In this question there is also no correct answer.
Still, I tried some of the answers from this thread
recipient.AddressEntry.Address
<= returns same thing asrecipient.Address
what I used till yet and what gievs me following result:"/o=POST/ou=Zuerich/cn=Recipients/cn=eicherr"
How can I get email adress of recipient?
I tried also
.AddressEntry.GetContact().Email1Address
and.AddressEntry.GetExchangeUser().Address
this all not works for me.Here is a MSDN docs explanes how to get email adress but I don't undestand how can I use it in my code Obtain the E-mail Address of a Recipient
my code:
Dim Msg As Outlook.MeetingItem Set Msg = Item Set recips = Msg.Recipients Dim recip As Outlook.Recipient For Each recip In recips Dim email as String email = CStr(recip.Address) Debug.Print email End For
原文:https://stackoverflow.com/questions/50387906
最满意答案
您可以将表连接到自身,以搜索超过一天的同一用户的条目。 如果没有一天的匹配,则左连接表中的字段将为NULL。
例如:
select YEAR(cur.ts) as year , MONTH(cur.ts) as month , DAY(cur.ts) as day , case when old.uuid is null then 1 else 0 end as IsNewUser , count(distinct cur.uuid) as Users from table2 cur left join table2 old on cur.uuid = old.uuid and old.ip <> 2 and old.id > 10 and cur.ts - old.ts > 1 where cur.ip <> 2 and cur.id > 10 group by year, month, day, IsNewUser order by year, month, day, IsNewUser
You can join the table on itself to search for entries for the same user that are more than a day old. When there's no day-old match, fields in the left joined table will be NULL.
For example:
select YEAR(cur.ts) as year , MONTH(cur.ts) as month , DAY(cur.ts) as day , case when old.uuid is null then 1 else 0 end as IsNewUser , count(distinct cur.uuid) as Users from table2 cur left join table2 old on cur.uuid = old.uuid and old.ip <> 2 and old.id > 10 and cur.ts - old.ts > 1 where cur.ip <> 2 and cur.id > 10 group by year, month, day, IsNewUser order by year, month, day, IsNewUser
相关问答
更多-
SELECT DISTINCT c.constit_id AS constitid, REPLACE (c.in_labelname, 'None', '') AS fullname, c.firstname AS firstname, c.lastname AS lastname, c.indiv_title AS title, e.e_addr AS email, 'InActive' ...
-
这是数据库的一个很好的候选者。 您可以拥有一个包含3个字段的表: IPAddress , Attemps , LastDate这样您就可以知道每个IP地址对当前的最后日期进行了多少尝试。 每当实际日期不再相同时,尝试计数重置为1.这是机制可能看起来像的伪代码: if (same date) { if (attemps < 5) { if (!try_connect()) { attemps++; } } else { e ...
-
按照特定列排序前24小时,然后按日期排序(Sort by certain column for the first 24 hours then order just by date)[2023-08-14]
假设你的意思是从现在开始24小时,你可以使用这样的东西 - select_ from [tablename] t order by case_sub(now(),INTERVAL 24 HOUR)您可以将表连接到自身,以搜索超过一天的同一用户的条目。 如果没有一天的匹配,则左连接表中的字段将为NULL。 例如: select YEAR(cur.ts) as year , MONTH(cur.ts) as month , DAY(cur.ts) as day , case when old.uuid is null then 1 else 0 end as IsNewUser , count(distinct cur.uuid) as Users from table2 cu ...您需要分隔您的字段名称,因为它们是保留关键字: SqlDataSource1.SelectCommand = "SELECT * FROM DataTable WHERE [Date]>'" + Time.ToShortDateString() + "' AND [Time]>'" + Time.ToShortTimeString() + "'" 这是选择SQL中不是保留字的字段名称的一个很好的理由。 如果这两个都是一个字段,那么您只需对日期和时间进行一次评估: WHERE查找在24小时内创建的记录(尤其是最近24小时)(Find records created in a period of 24hours (not especially the last 24hrs))[2022-07-30]
一个相当痛苦的方式来做到这一点(性能明智的)是与join / group by或apply运营商。 从性能角度来看, apply应该更好: select t.* from t cross apply (select count(*) as cnt from t t2 where t2.iduser = t.iduser and t2.creationdate >= t.creationdate and t2.creationd ...检查它是否在24小时内发生(check if it happens in 24 hours)[2022-05-10]
不要在PHP中检查它,使用这样的简单查询来直接从数据库中获取答案。 select count(*) from yourTableName where dateCol>date_sub(now(), interval 1 day) and userID=... 这将给你计数。 编辑:正如鲍里斯指出的那样,这将计算每天,您可以更改它以检查最后24小时的时间段,如下所示: select count(*) from yourTableName w ...在过去24小时内显示历史记录表中两个用户的交易(show transactions for two users in history table within the last 24 hours)[2023-10-29]
问题是OR。 您想要时间和买方/卖方条件。 你想要买家/卖家的OR。 $query = Doctrine_Query::create() ->select('th.*') ->from('TransactionHistory th') ->where('th.transaction_end_time > ?', date('Y-m-d H:i:s', time() - 86400)) ->andWhere('th.transaction_buyer_id = ? OR th. ...如果您只是要合并结果,可以使用union http://dev.mysql.com/doc/refman/5.7/en/union.html (SELECT `Price` FROM `".$this->symbol."Trades` ORDER BY `ts` DESC LIMIT 1) UNION (SELECT `Price` FROM `".$this->symbol."Trades` WHERE `ts` >= DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY ...从SQL获取最近24小时的数据(Get last 24 hours data from SQL)[2024-02-12]
SELECT * FROM stats WHERE STR_TO_DATE(timespan,"%W, %b %d %Y, %h:%i:%s %p") >= date_sub(now(), INTERVAL 1 DAY) STR_TO_DATE会将您的字符串转换为日期格式(Ymd H:i:s)然后您可以将它与now()返回的日期进行比较 SELECT * FROM stats WHERE STR_TO_DATE(timespan,"%W, %b %d %Y, %h:%i:%s %p") >= date_s ...相关文章
更多- 求一个java包 saif-spring.jar
- HowToMakeCustomSearch
- 找回密码
- mysql问题
- Java 发送邮件
- wordpress wp_mail
- 急,一个关于frame里面新增事件的问题<frame id="contetnt" src="" ></frame>
- 微信公众平台企业订阅号注册流程
- 自定义Git-git入门教程
- Gaea-58.com跨平台高性能高可用中间层服务框架
最新问答
更多- 您如何使用git diff文件,并将其应用于同一存储库的副本的本地分支?(How do you take a git diff file, and apply it to a local branch that is a copy of the same repository?)
- 将长浮点值剪切为2个小数点并复制到字符数组(Cut Long Float Value to 2 decimal points and copy to Character Array)
- OctoberCMS侧边栏不呈现(OctoberCMS Sidebar not rendering)
- 页面加载后对象是否有资格进行垃圾回收?(Are objects eligible for garbage collection after the page loads?)
- codeigniter中的语言不能按预期工作(language in codeigniter doesn' t work as expected)
- 在计算机拍照在哪里进入
- 使用cin.get()从c ++中的输入流中丢弃不需要的字符(Using cin.get() to discard unwanted characters from the input stream in c++)
- No for循环将在for循环中运行。(No for loop will run inside for loop. Testing for primes)
- 单页应用程序:页面重新加载(Single Page Application: page reload)
- 在循环中选择具有相似模式的列名称(Selecting Column Name With Similar Pattern in a Loop)
- System.StackOverflow错误(System.StackOverflow error)
- KnockoutJS未在嵌套模板上应用beforeRemove和afterAdd(KnockoutJS not applying beforeRemove and afterAdd on nested templates)
- 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
- android - 如何避免使用Samsung RFS文件系统延迟/冻结?(android - how to avoid lag/freezes with Samsung RFS filesystem?)
- TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
- 企业安全培训的各项内容
- 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
- C#类名中允许哪些字符?(What characters are allowed in C# class name?)
- NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
- 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
- 将多个行和可变行移动到列(moving multiple and variable rows to columns)
- 提交表单时忽略基础href,而不使用Javascript(ignore base href when submitting form, without using Javascript)
- 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
- Angular $资源不会改变方法(Angular $resource doesn't change method)
- 在Angular 5中不是一个函数(is not a function in Angular 5)
- 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
- 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
- 常见的python rpc和cli接口(Common python rpc and cli interface)
- Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
- 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)