Community
Showing results for 
Search instead for 
Do you mean 
Reply

Email Replace only Domain

Highlighted
Copper Contributor
Posts: 73
Country: USA

Email Replace only Domain

I have over a hundred contacts whose domain is changing

What is an efficient way to change only everything after the person's name:

example: John.Doe@CurrentDomain.com to John.Doe@NewDomain.com

 

Thanks

 

 

Highlighted
Nickel Elite Contributor
Posts: 619
Country: USA

Re: Email Replace only Domain

Hello,

 

Unfortunately, directly by Act! I do not know of a method that allows you to update only the domain

 

But a SQL Server expert can do this operation...

 

...

A1.png

 

The person or office that makes the service needs you to have installed the SQL server management studio and Restart your computer before local or remote service CLICK

 

 

 

Anyway, I suggest:

 

1. Back up the database before any procedure that involves changing the volume of records

2. Make that EMAIL UPDATE in a test database, with the backup you made in the previous point ... you restore it as TESTDB, this way it does not affect the production database in case something goes wrong

 

 

Best regards and good luck

 

...

FIRMA.png

 

...

 

 

 

Juan Carlos Otero Garcia
juancarlosotero@protonmail.com
Highlighted
Administrator
Posts: 1,379
Country: United_Kingdom

Re: Email Replace only Domain

As Juan has said, unfortunately, 'partial replace' is not a feature of Act! You can use the the tools in the Edit menu to overwrite data in a particular field, for a particular lookup, but it will entirely replace the data entirely - not just the domain.

You can find more info on the Edit Menu tools here:
http://kb.act.com/app/answers/detail/a_id/38137

You could make the changes directly in SQL as Juan has suggested above - but bear in mind, Swiftpage does not support/condone making direct changes to the SQL - meaning if something goes wrong, we won't be able to help you fix it.

Highlighted
Bronze Elite Contributor
Posts: 1,779
Country: United_Kingdom

Re: Email Replace only Domain

Hi ark210,

 

You could try the free Act! addon from Xact...

 

https://www.xactsoftware.co.nz/free-act-addons/#3

 

HTH


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org 
Highlighted
Nickel Elite Contributor
Posts: 619
Country: USA

Re: Email Replace only Domain

[ Edited ]

I already did the test THE ADDON  with DEMO DATABASE and it worked correctly

The only thing you should keep in mind is that before you can make the first Domain change, the system asks you to create a FREE account, take note of the EMAIL and Password that you will use for that account.

Please note that changing the email address with this ADDON does not leave a history record

 

The email must be correct because you will receive an email with the LINK to activate the account

 

...Click on the image to enlarge

1.png

 

...Click on the image to enlarge

2.png

 

...Click on the image to enlarge

3.png

 

 


Best regards and good luck,

 

FIRMA.png

 

 

Juan Carlos Otero Garcia
juancarlosotero@protonmail.com
Highlighted
Copper Contributor
Posts: 73
Country: USA

Re: Email Replace only Domain

Perfect Easy Solution
Highlighted
Bronze Elite Contributor
Posts: 1,779
Country: United_Kingdom

Re: Email Replace only Domain

Hi ark210,

 

Please could you mark my reply above as The Solution.


David Shaw
Act! Certified Consultant since 2001
Office:    +44 (0)1483 714507
Mobile: +44 (0)7977 567 318
E-Mail:    dshaw@act4u.org