Home > Software engineering >  Bulk email
Bulk email

Time:11-08

I have a demand, a great god can help to write down the VBA program?

Basic requirements are as follows: open the mailbox foxmail,

Read specific (open) according to the file path in the excel spreadsheet A2 cells as email address, read the same in the excel spreadsheet B2 as email subject, read the same in the excel spreadsheet C2 as email body, starting from the second row fetching in turn email address, title and body, and in turn to send, until all of the mail, after such a demand can be done?

CodePudding user response:

Foxmail?
Let's use outlook;
But you are such a hair a lot is likely to be seen as spam and be screened by the server.

CodePudding user response:

Please refer to the article: https://zhuanlan.zhihu.com/p/88767610 Excel VBA programming application development series (18) - E-mail group,

CodePudding user response:

Using mapi interface, call your mail client (outlook foxmail)

CodePudding user response:

Use the mail merge function of the word,

CodePudding user response:

Use the mail merge function of the word, use the mail merge function of the word,,
  •  Tags:  
  • VBA
  • Related