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