[AccessD] mailto: in excel export of email address

[Stuart McLachlan]

Give it a try.  Excel does all sorts of weird things, this is one of them.  A leading apostrophe is 
treating as a "text indicator".  Try entering '42 for example into a cell

Although you will see the leading apostrophe in the formula bar, you won't see it in the actual 
spreadsheet,   

If you select the cells and copy and paste them into some other application, the apostrophe 
won't be carried across.

If you "paste values" in the spreadsheet, it won't carry the apostrophe across (although a 
standard paste will)



On 3 Sep 2015 at 7:27, Rocky Smolin wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>