Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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?



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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?

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you send an excel file as a link in an email in excel 2007 James Pearson Excel Discussion (Misc queries) 1 July 29th 08 03:46 PM
Can't send an attachment in Excel 2007 Stephen Excel Discussion (Misc queries) 0 November 2nd 07 10:55 PM
Import text file into Excel 2007 then copy sheet to another workbo DonnaO Excel Discussion (Misc queries) 2 October 9th 07 07:09 PM
unable to send excel file as attachment tab greyed out in file com Wayne Excel Discussion (Misc queries) 0 April 13th 06 10:06 PM
CSV file for inporting contact list from Hotmail to Gmail using Ex Jesterzone Excel Discussion (Misc queries) 2 August 21st 05 05:21 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"