VBA选择随机电子邮件地址 [英] VBA to select random email address

问题描述

大家好，我有一些VBA代码附加到一个按钮上，该按钮填充报告以供我的团队审核。


我不知何故需要确保这些请求是交替的在两个团队成员之间，因此无法将电子邮件地址硬编码到代码中。


我有什么方法可以替代发送电子邮件的人？目前我有类似的东西（注意这是我的代码和整个事情的一部分）：

Hi All, I have some VBA code attached to a button which populates a report to be reviewed by one of my team.

I somehow need to make sure these requests are alternated between the two team members and therefore cannot hardcode the email address into the code.

Is there any way I can alternate who the email is sent to? Currently I have something like this (note this is part of my code and ot the entire thing):

展开 | 选择 | 换行 | 行号

推荐答案

在发布代码或格式化数据时请使用代码标签。


您想要随机还是实际想要交替使用？

Please use code tags when posting code or formatted data.

Do you want random or do you actually want alternating?

抱歉 - 将来一定会使用代码标签。

Sorry - will be sure to use code tags in future.

@Rabbit


对不起 - 没有问题（仍然只是新的和学习的）。


我实际上是在交替发送电子邮件之后。因此，每次我发送它进行审核时，它都会转移到下一个团队成员并通过电子邮件发送给他们。


感谢您的帮助。

@Rabbit
Sorry - no problems (still only new and learning).

I''m actually after alternating emails. So each time I send it for review it moves to the next team member and emails them.

Thanks for your help.

这篇关于VBA选择随机电子邮件地址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！