Hi,

Thanks for the replies,

So far the users are just instructed to use Save As to change the file format to .CSV. This is because our mail manager software does not read anything other than CSV to convert to .DBF.

Not to mention we have this bug which development refuses to fix that if you save in unicode .TXT it corrupts the data. Their work-around is to just use Save As. Great workaround, only problem is that users forget so I'd rather have a macro to auto-save this to .CSV everytime. Using advanced options in excel does not work unfortunately.