Need Macro to automate email from excel

Microsoft Excel 2010
May 19, 2011 at 05:56:21
Specs: Windows 7
Windows 7

First thing...I know nothing about macros!! I do know a very little about formulas

I have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"send
works great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?
Thank u

See More: Need Macro to automate email from excel

Report •

May 26, 2011 at 07:02:35
I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

Report •

June 1, 2011 at 10:42:34
I have a maintenence sheet already built in excel, 100 machines that require PM maintenence constantly, the sheet is very large and has a lot of updated notes on it. I wrote the "IF" link and it works well but takes me a lot of time to send each email out manually and if I take time off, well no emails go i would like to get a macro to do the sending of the email, I understand the program would have to be left open to work, I'm will to do that...let me know please

Report •

Related Solutions

Ask Question