>>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?