Excel/Outlook mail add-in version for Excel 2007 Beta2 TR
Hi all
Here is the first Excel/Outlook mail add-in version for Excel 2007 Beta2 TR.
The versions for 97-2003 you can find here : http://www.rondebruin.nl/mail/add-in.htm
You can use it for xls, xlsx, xlsm, xlsb files.
It always save the new file you create in the same format as the Activeworkbook.
Only if you want to send a sheet from an xlsm file and there is no code then it save it as xlsx.
There is also an option to send as PDF (you must install the MS PDF add-in for that).
It will check if the add-in is installed on the machine when you open the add-in.
There is a limit of 30000 cells now for the Selection/PDF options.
Not sure about the limit but I start with this.
Link to the MS PDF add-in
http://www.microsoft.com/downloads/details.aspx?FamilyID=f1fc413c-6d89-4f15-991b-63b07ba5f2e5&DisplayLang=en
If Winzip is installed you can also use the Zip option (Shift>Go).
Download it here
http://www.rondebruin.nl/files/SendMail2007.zip
There is a option to open the Add-in in the Cell menu.
Ron de Bruin
http://www.rondebruin.nl
Ron de Bruin:
Hi all
I update 22 pages with code that is working in 97-2007 or 2000-2007.
I changed all code to Late binding with a example on the bottom of each
page to change it to Early binding (less private mail I hope (grin)
Lot of checking needed in the code for the new file formats in Excel 2007
I also add three example workbooks, I hope this will help users.
28 October 2006, 8:31 amhttp://www.rondebruin.nl/sendmail.htm