Community
Showing results for 
Search instead for 
Do you mean 
Reply

Can a Character Field be Converted to an e-mail field

Accepted Solution Solved
Bronze Super Contributor
Posts: 1,488
Country: USA
Accepted Solution

Can a Character Field be Converted to an e-mail field

I just noticed that I created a character field to hold bounced eMail addresses.  I have already added several hundred so I would like to avoid starting over.

 

Is it possible to convert that field to an eMail field?

John Purdy
ACT! Premium V. 20.0.159
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.

Accepted Solutions
Highlighted
Solution
Accepted by topic author jnpurdy
‎03-20-2019 05:59 AM
Platinum Elite Contributor
Posts: 6,860
Country: USA

Re: Can a Character Field be Converted to an e-mail field

To my knowledge no. I believe an email field can only be declared when created. I don't believe that a character field can be copied to an email field though it would be worth a try. The best bet would be to export the contact field and the email data to Excel. Create a new email field and then merge the Excel file back in.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Highlighted
Solution
Accepted by topic author jnpurdy
‎03-20-2019 05:59 AM
Platinum Elite Contributor
Posts: 6,860
Country: USA

Re: Can a Character Field be Converted to an e-mail field

To my knowledge no. I believe an email field can only be declared when created. I don't believe that a character field can be copied to an email field though it would be worth a try. The best bet would be to export the contact field and the email data to Excel. Create a new email field and then merge the Excel file back in.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,584
Country: Australia

Re: Can a Character Field be Converted to an e-mail field

Create a new email field and use Edit > Copy from the old one.
I haven't tried this, so not sure how the email table handles it. But the email fields do show in the list.
Backup first