how to copy and send excel file 2007 to hotmail customers
 

How can I save an excel 2007 file attachment and then send or forward to
hotmail customer

how to copy and send excel file 2007 to hotmail customers
 

hi billwoaks

See
http://www.rondebruin.nl/sendmail.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"billwoaks" wrote in message ...
How can I save an excel 2007 file attachment and then send or forward to
hotmail customer

how to copy and send excel file 2007 to hotmail customers
 

Ron
The Email code is a great help.
Is there code to add it to a compressed file before sending?

how to copy and send excel file 2007 to hotmail customers
 

In rowsing Ron's site I have found the zip code so will try to adapt for my
purposes.
Very helpful site Ron.
Thank you!

how to copy and send excel file 2007 to hotmail customers
 

Using Ron's code to try zipping an xls worksheet, namely:
'Sub Zip_ActiveWorkbook()
Dim strDate As String, DefPath As String
Dim FileNameZip, FileNameXls
Dim oApp As Object
Dim FileExtStr As String


'Create empty Zip File
NewZip (FileNameZip)"

A compile error occurs: Sub or Function not defined.

Is the function available in Excel 2007?

how to copy and send excel file 2007 to hotmail customers
 

Is the function available in Excel 2007?

You can find it on the same page
Read the "Important" section on this page
http://www.rondebruin.nl/windowsxpzip.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Murph" wrote in message ...
Using Ron's code to try zipping an xls worksheet, namely:
'Sub Zip_ActiveWorkbook()
Dim strDate As String, DefPath As String
Dim FileNameZip, FileNameXls
Dim oApp As Object
Dim FileExtStr As String


'Create empty Zip File
NewZip (FileNameZip)"

A compile error occurs: Sub or Function not defined.

Is the function available in Excel 2007?

how to copy and send excel file 2007 to hotmail customers
 

Thanks Ron
The zip email is working.
Cheers
Murph
"Ron de Bruin" wrote in message
...
Is the function available in Excel 2007?

You can find it on the same page
Read the "Important" section on this page
http://www.rondebruin.nl/windowsxpzip.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Murph" wrote in message
...
Using Ron's code to try zipping an xls worksheet, namely:
'Sub Zip_ActiveWorkbook()
Dim strDate As String, DefPath As String
Dim FileNameZip, FileNameXls
Dim oApp As Object
Dim FileExtStr As String


'Create empty Zip File
NewZip (FileNameZip)"

A compile error occurs: Sub or Function not defined.

Is the function available in Excel 2007?