Hi all
I have create a new worksheet template for Excel/Outlook 2007-2010 for mailing this week.
(with great suggestions from Dave Peterson)
You can download it here
http://www.rondebruin.nl/mail/outlooksheettemplate.htm
I think on this moment it have a lot of mail options that are very easy to change/use.
You can mail one or many custom mails with one click of a button.
But I love to hear what you miss in this template or not like in it.
Read the information on the webpage and in each data validation tip that you can find in each cell
and let me know if you have suggestions.
Thank you very much
Ron de Bruin
http://www.rondebruin.nl/tips.htm
Nifty!
I particularly like the ‘auto install’ workbook. I think I may have to use that. Now I just need to come up with a reason to. :)
Ron,
First of all, nice work as usual :)
Second, I would like to see that You add a priority field where the user can select between Low, Normal and High and where the default value would be Normal.
Most users only use one e-mail account so I guess the need to select from which e-mail account to send e-mails may not be of high interest (except for the group of consultants ;))
Kind regards,
Dennis
Hi Dennis
Good suggetion about priority
In 2007 we can change accounts with code
http://www.rondebruin.nl/mail/account.htm
But I can’t get the code to work with Late binding the last time I try
Test: I not see my comment to Dennis so this is a test
The following is on Ron’s behalf as he has trouble to posts comments here.
**************************************************************************
Hi Dennis
Good suggestion Dennis about Priority
In 2007 it is not so difficult to change accounts, see
http://www.rondebruin.nl/mail/account.htm
But I am not able to change this example to Late binding
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
Thew following comment is on behalf of Ron:
***************************************************************
Hi Dennis
Good suggestion Dennis about Priority
In 2007 it is not so difficult to change accounts, see
http://www.rondebruin.nl/mail/account.htm
But I am not able to change this example to Late binding
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
Both Ron and Dennis got caught in Akismet spam filter. I know that spam filter doesn’t like Ron, but I thought they became friends. Now it doesn’t like Denis either. I don’t check that filter often because it rarely makes mistakes, so be sure to send me an email if your comment doesn’t show up. Thanks, DK.
At least I’m in a good company ;)
Thanks Dick.
Kind regards,
Dennis
Hi Dennis
At least I’m in a good company ( I agree with that)
If I bring Dutch Heineken Beer and you the swedish meat balls we have a good time Dennis.
Ron – Excellent and don’t forget the Dutch cheese which I really like ;)
Hi all
I update the sheet template today, add importance option and change it to a xlt(97-2003 template) to avoid problems
if you want to insert in in a 97-2003 workbook in Excel 2007-2010.
And I add a new one to send PDF ‘s instead of workbooks
http://www.rondebruin.nl/mail/outlooksheettemplatepdf.htm