[AccessD] mailto: in excel export of email address

[Rocky Smolin]

I'll give that a go.  Though it's hard to test because I can't replicate it.
I'll have to implement it and send it to the client for testing.

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Wednesday, September 02, 2015 11:15 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] mailto: in excel export of email address

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