[AccessD] mailto: in excel export of email address

Stuart McLachlan stuart at lexacorp.com.pg
Wed Sep 2 17:22:53 CDT 2015


It's a long term  Excel "feature".  

https://support.microsoft.com/en-us/kb/291209

You probably have the Autoformat optione turned off in Exccel while the cilent has it turned 
on.

Suggest you try using the  option of prepending an apostrophe to that field inr your export 
query.


On 1 Sep 2015 at 14:14, Rocky Smolin wrote:

> Dear List:
> 
> I'm using TransferSpreadsheet on a table that has an email address in
> a text field.  when I export no problem, but when the client exports
> the email address shows up in the spreadsheet with 'mailto:' prefixed
> to each email address.  I'm using 2003.  She is using 2010 or perhaps
> 2013 (hard to tell from the screen shot). 
> 
> Is this something that 2010 is adding?  Is there a solution?
> 
> MTIA,
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> Skype: rocky.smolin
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list