I have an application that runs on remote laptops. These connect to the
corporate network through a VPN but mostly are not connected.

The laptops have a drive that maps to the network at log on and synchronises
files to the network.

My applicatiion create a CSV file on this drive, which is stored on the
local PC, this works and I can open this file as required. Where I have a
problem is that when I try to attach this file to an email (Outlook) I get an
error 'cannot access datastore' which suggest it is looking for the network
drive NOT the local file just created?

I can open the CSV file directly within Excel but if I try to attach to an
email I get the error.

Any thoughts how I can overcome this?