在Excel上发送截止日期的电子邮件通知 [英] Email notification for due date on excel
问题描述
大家好
我很擅长使用VBA，宏和模块。
我正在寻找创建一个在excel中我收到电子邮件通知的文档，文档已经过了它的截止日期以供审核。审核截止日期为"上次审核日期"后365天。我正在努力构建宏以允许我这样做。
该文档将包含以下标题列表。
部门 文档名称 版本号 上次审核日期 文档所有者发送电子邮件
任何人都可以帮助我吗？
谢谢，
史蒂文
Hi Steven，b
>>我想在excel中创建一个文档，我收到一封电子邮件通知文件已经过了它的截止日期。
我不知道是什么你的意思是"电子邮件通知"。根据您的描述，您似乎想要在工作表中创建一个表，并向表中添加行。如果是这样，我认为你可以使用ListObjects.Add创建一个表，然后使用ListRows.Add添加
a新行，然后你可以设置单元格的值。
＃ListObjects.Add方法（Excel）
https://msdn.microsoft.com/EN-US/library/office/ff823155.aspx
＃ListRows.Add Method（Excel）
https://msdn.microsoft.com/EN-US/library/office/ff196248。 aspx
对于一般建议，我认为您可以手动创建带有录音的表格，然后在vba中检查生成的代码，然后根据自己的要求修改它。
最好的问候，
Edward
Hi All
I'm fairly new to using VBA, Macros and Modules.
I'm looking to create a document in excel where I receive an email notifications a document has passed it's due date for review. The review due date would be 365 days after the 'Last reviewed Date'. I'm struggling to build the macro to allow me to do this. the document will have the following headers for a list.
Department Document Name Version No. Last Review Date Document owners email
Can anyone help me out?
thanks,
Steven
Hi Steven,
>> I'm looking to create a document in excel where I receive an email notifications a document has passed it's due date for review.
I am not sure what you mean with "email notification". Based on your description, it seems that you want to create a table in a sheet, and add rows to the table. If so, I think you could ListObjects.Add to create a table, and then use ListRows.Add to add a new row, then you could set the value of the cell.
# ListObjects.Add Method (Excel)
https://msdn.microsoft.com/EN-US/library/office/ff823155.aspx
# ListRows.Add Method (Excel)
https://msdn.microsoft.com/EN-US/library/office/ff196248.aspx
For a general suggestion, I think you could manually create a sheet with recording, then check the generated code in vba, and then modify it as your own requirement.
Best Regards,
Edward
这篇关于在Excel上发送截止日期的电子邮件通知的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
