公司里要给约有450个supervisor发e-mail.
所有e-mail 内容都一样(我知道仅这样可以用WORD中的MAIL MERGE)
但是，我需要给每一个supervisor发不同的附件。
说得再具体一些是这样:
We have an excel file which we put in employees stock option info and their supervisor's names and e-mail addresses.
We need to send each supervisor a copy of their workers' stock option info.
What I did is pretty time-consuming. I sort the excel file by supervisor's name(or their e-mail address), then I copy their workers info to a seperate worksheet and save it. ( I name the seperate worksheet as the supervisor's name). Basically, this worksheet is the attachment I like to send out to each supervisor.
When I sent out the e-mail. I need to copy the same e-mail content again and again and pick up the attachment I need.
I wonder is there an automatic way to sovle this problem? It's my first time inten in U.S. Thanks for your advise.