[AccessD] mailto: in excel export of email address

[Bill Benson]

I would expect it to wrap it in a double quote or some other weirdness but
I hope you are right Stuart, I always root for the good guys and the white
hats.
On Sep 3, 2015 5:53 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

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