>>>I have a little project. The user will use a VFP interface to select procurement items from a list. The VFP app will then package the items with formulas in an Excel sheet and email them to Vendors. The vendors will enter unit prices and return (send back) the completed Excel spread sheet to the [procurement] user's mailbox.
>>>
>>>The problem is that my design creates one spreadsheet (one file name). When they are returned, they will all have the same name. This may conflict (overwrite) previously received documents of the same name. AT the very least, it would confuse my user.
>>>
>>>My options are to create a seperate (but same) spreadsheet for each vendor with automation, or rename the "master" sheet file prior to each mailing.
>>>
>>>Those options seem excessive. Is there a way I can rename an attachment on the fly? Is there a cleaner way to do this than my recognized options.
>>>
>>>Thanks
>>
>>How do you send the email?
>
>The user is an outlook shop - but I am open to suggestions. Also - I am fairly ignorant of VFP automation and email. I've saved some thread pointers related to MAPI and Outlook automations, but have never applied them. What would you suggest?

As I understand this, it is a manual sending and receiving.
The user send the same file to many places and you expect that this user will be able to save the file with a different name when the file return...
A bit of education and all should be OK :) (in your dreams only<g>)

I dont think that you really have other alternative than naming the file before sending it.
If there is many recipients, you can send it directly via SMTP from the app.
BTW, there is a good article in the UT Mag (march 2004) that explain in great details how to use SMTP in VFP.

HTH :-)