[QtonPi] About the distribution of personal codes

Tim Beaulen tbscope at gmail.com
Sat Dec 10 19:31:21 CET 2011


On Sat, Dec 10, 2011 at 7:14 PM,  <quim.gil at nokia.com> wrote:
> PS: does anybody know the easiest way to send 400 emails to 400 destinations with 400 different codes with a spreadsheet containing the data? Otherwise I'm facing 400 automatic replies: not funny.

If you're using excel you can write a simple vba scipt.

Example, for each row:

With CreateObject("Outlook.Application").createitem(olMailItem)
 .To = "abc at def.com"
 .Subject = "Your Pi code"
 .body = "..." <-- use the columns and rows to build the body.
 .Send
End With


More information about the QtonPi mailing list