I have Excel 2002. I have a spreadsheet that I need to convert to csv format
and email each week to another person. My macro does a save as to convert it
from xls to csv ... is there any way I can automatically overwrite the old
file so it doesn't ask me each time about overwriting the file. Also, when
the macro opens Outlook, is there anyway I can use the macro to
automatically enter the email address and send the email, or do I have to do
it manually each time ? Can a macro jump from Excel to Outlook and then back
again ?

thanks ... Roger

See Ron de Bruin's site
Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm



--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Roger" wrote in message
...
I have Excel 2002. I have a spreadsheet that I need to convert to csv
format and email each week to another person. My macro does a save as to
convert it from xls to csv ... is there any way I can automatically
overwrite the old file so it doesn't ask me each time about overwriting
the file. Also, when the macro opens Outlook, is there anyway I can use
the macro to automatically enter the email address and send the email, or
do I have to do it manually each time ? Can a macro jump from Excel to
Outlook and then back again ?

thanks ... Roger

To prevent the message when you overwrite a file add

Application.DisplayAlerts = False

your save code goes here

Application.DisplayAlerts = True

Bernard looked after the sending of mail in his reply.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 16:01:13 +0100, "Roger" wrote:

I have Excel 2002. I have a spreadsheet that I need to convert to csv format
and email each week to another person. My macro does a save as to convert it
from xls to csv ... is there any way I can automatically overwrite the old
file so it doesn't ask me each time about overwriting the file. Also, when
the macro opens Outlook, is there anyway I can use the macro to
automatically enter the email address and send the email, or do I have to do
it manually each time ? Can a macro jump from Excel to Outlook and then back
again ?

thanks ... Roger

Thanks for your help, www.rondebriun.nl is a very good site for this sort of
stuff, thanks again

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
To prevent the message when you overwrite a file add

Application.DisplayAlerts = False

your save code goes here

Application.DisplayAlerts = True

Bernard looked after the sending of mail in his reply.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 16:01:13 +0100, "Roger" wrote:

I have Excel 2002. I have a spreadsheet that I need to convert to csv
format
and email each week to another person. My macro does a save as to convert
it
from xls to csv ... is there any way I can automatically overwrite the old
file so it doesn't ask me each time about overwriting the file. Also, when
the macro opens Outlook, is there anyway I can use the macro to
automatically enter the email address and send the email, or do I have to
do
it manually each time ? Can a macro jump from Excel to Outlook and then
back
again ?

thanks ... Roger