Clorox
07-11-2006, 08:04 AM
I've got several e-mail requests I make each month for information from hedge fund managers regarding their portfolios (% invested in a specific region, % cash, etc.).
I request the same information from the same people each month, but each e-mail is unique because I'm writing a single, specific e-mail to a specified person regarding their fund and I am requesting information that relates only to that fund.
However, I do this every month for about a dozen managers, and the only thing that changes in the subject and body are the month to which I am referring (so every time a new month comes around I copy and paste my old e-mail text and subject into a new e-mail addressed to the person and put in the new date info and send it off). I'd like to be able to automate it so that when I run my code it asks me for the date string (doesn't have to be in a date format, it can be 5/31/06 or May 31, 2006, any old text string really) and automatically creates the individual e-mails in my draft folders addressed properly with the specified subject (with the proper date) and proper body text. Is there a way for me to write this in VBA?
Thanks!
I request the same information from the same people each month, but each e-mail is unique because I'm writing a single, specific e-mail to a specified person regarding their fund and I am requesting information that relates only to that fund.
However, I do this every month for about a dozen managers, and the only thing that changes in the subject and body are the month to which I am referring (so every time a new month comes around I copy and paste my old e-mail text and subject into a new e-mail addressed to the person and put in the new date info and send it off). I'd like to be able to automate it so that when I run my code it asks me for the date string (doesn't have to be in a date format, it can be 5/31/06 or May 31, 2006, any old text string really) and automatically creates the individual e-mails in my draft folders addressed properly with the specified subject (with the proper date) and proper body text. Is there a way for me to write this in VBA?
Thanks!