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
Highlighted
Bronze Super Contributor
Posts: 1,550
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. 22.0.205.0 Update 3
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor

Accepted Solutions
Highlighted
Solution
Accepted by topic author jnpurdy
‎03-20-2019 05:59 AM
Platinum Elite Contributor
Posts: 6,867
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

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,867
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
Highlighted
Platinum Elite Contributor
Posts: 14,650
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