需要一个VB代码，用于过滤邮件ID并从Excel工作表制作.pdf并将邮件发送到过滤器电子邮件。 [英] Need a VB code that filter mail id and make a .pdf from excel sheet and send mail to a filter email.

问题描述

INV no。名称。电子邮件

22. Abc。 [e-mail]

23. Xyz。 [e-mail]

24. Opq。 [e-mail]

222. Abc。 [e-mail]

223. Xyz。 [e-mail]

224. Opq。 [e-mail]



我们需要按名称每月发送一份发票确认函。因此，按电子邮件ID过滤并制作单个.pdf的发票并发送到相同的ID。



我尝试过：

INV no. Name. Email
22. Abc. [e-mail]
23. Xyz. [e-mail]
24. Opq. [e-mail]
222. Abc. [e-mail]
223. Xyz. [e-mail]
224. Opq. [e-mail]

We need to send a monthly confirmation of invoice by name. So filter by email id and make a single .pdf of invoice and send to a same id.

What I have tried:

Selection.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:="C:\Users\marks\Documents\Saved PDF.pdf"

'Save a chart as PDF

推荐答案

它不太像那个。

我们不会为你工作。

如果你想让别人写你的代码，你必须付钱 - 我建议你去Freelancer.com和在那里问。



但要注意：你得到的是你付出的代价。支付花生，买猴子。



发展的概念就像这句话所暗示的那样：系统地运用科学和技术知识来满足特定的目标或要求。 BusinessDictionary.com [ ^ ]

这与有一个不一样快速谷歌并放弃，如果我找不到完全正确的代码。

所以要么付钱给别人去做，要么学会如何自己写。我们不是为你做这件事。

It doesn't quite work like that.
We do not do your work for you.
If you want someone to write your code, you have to pay - I suggest you go to Freelancer.com and ask there.

But be aware: you get what you pay for. Pay peanuts, get monkeys.

The idea of "development" is as the word suggests: "The systematic use of scientific and technical knowledge to meet specific objectives or requirements." BusinessDictionary.com[^]
That's not the same thing as "have a quick google and give up if I can't find exactly the right code".
So either pay someone to do it, or learn how to write it yourself. We aren't here to do it for you.

这篇关于需要一个VB代码，用于过滤邮件ID并从Excel工作表制作.pdf并将邮件发送到过滤器电子邮件。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！