[AccessD] mailto: in excel export of email address

[Bill Benson]

the only workaround I can think of is to use a recordset instead, automate
excel, open the workbook, and use Rng.CopyFromRecordset.
On Tue, Sep 1, 2015 at 5:14 PM, Rocky Smolin <rockysmolin at bchacc.com> 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
>