[AccessD] mailto: in excel export of email address

Rocky Smolin rockysmolin at bchacc.com
Thu Sep 3 09:27:02 CDT 2015


Stuart:

Won't that have the effect of the email address in the spreadsheet having an
apostrophe in the first position?

Rocky
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, September 02, 2015 3:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] mailto: in excel export of email address

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
> 


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