Community
Showing results for 
Search instead for 
Do you mean 
Reply

Better Way To Add History To Large Group Of Contacts

Accepted Solution Solved
Bronze Contributor
Posts: 1,393
Country: USA
Accepted Solution

Better Way To Add History To Large Group Of Contacts

I use Microsoft Word's mail merge instead of ACT to take advantage of Word's features.

 

The contact list is created in ACT and then exported to Excel.

 

I then use the list created in act to create a short history about what was sent (instead of attaching the whole eMail).

 

In this case the number of records is 1,200. 

 

In creating the history, it is taking a very long time - so far over 20 minutes for the system to write the history to the contact records. 

 

What I did was:

  • Create a lookup of those receiving the eMail
  • Under the history tab right click to record history
  • To the right of the Contact field, clicked on the contact button and selected Current Lookup from the "Select from" dropdown
  • In Regarding entered a short description of the eMail that was sent

Is there a better way to do this?

 

John Purdy
ACT! Premium 2016 (V. 18)
Main: HP 9470M 8GB, Win 10 Pro, & Exchange 2013 & Office 365, 32bit
Remote: Dell XPS Ultrabook with 4GB & Win 10 Pro, Office 365 32bit & Exchange 2013

Accepted Solutions
Solution
Accepted by topic author jnpurdy
‎12-08-2016 05:03 AM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

Hi John,

For these types of outbound email volumes, I would strongly recommend using an emarketing platform like Act emarketing to create or import templates, send out the messages from external mail servers, manage deliverability, avoid spam classification and handle reporting and history recording back into Act.

Mail Merge by nature is not particularly well suited for sending emails to more than a few tens of recipients. I know there are a couple issues with the functionality of Act Mail Merges that are also limiting right now (these are high on the to-fix list), but I would advise you consider changing your approach to sending out these numbers of emails to gain some pretty worthwhile benefits.

View solution in original post


All Replies
Silver Contributor
Posts: 1,813
Country: USA

Re: Better Way To Add History To Large Group Of Contacts

I"m not sure it it's faster, but I think simpler.

Do your lookup first

go to contact list.

Tag All 

CTRL+H or Click on REcord History

 

 

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider

Bronze Contributor
Posts: 1,393
Country: USA

Re: Better Way To Add History To Large Group Of Contacts

Thanks for the tip to enter a history record without being on the history tab.

John Purdy
ACT! Premium 2016 (V. 18)
Main: HP 9470M 8GB, Win 10 Pro, & Exchange 2013 & Office 365, 32bit
Remote: Dell XPS Ultrabook with 4GB & Win 10 Pro, Office 365 32bit & Exchange 2013
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

Hi John,

Adding 1,200 history records will be a slow process. Jon's suggestion would however be a more efficient method.

Could you help us understand why you have chosen to use Microsoft Word's mail merge feature for your emails instead of Act? What Word specific features are you taking advantage of? This kind of feedback is useful for our ongoing product development.
Bronze Contributor
Posts: 1,393
Country: USA

Re: Better Way To Add History To Large Group Of Contacts

Handling graphics especially when being sent to other than Outlook recipients.

 

Besides, Word can work on sending out a long list while I continue to work with ACT.  After sorting by eMail address for more random eMail deliveries, I typically send only 40 - 50 at a time to avoid SPAM identification.

 

I don't see how Jon's suggestion would be more efficient, if efficient translates to faster.  I do see how it is easier to bring up the dialogue box. 

 

Or am I missing something?

John Purdy
ACT! Premium 2016 (V. 18)
Main: HP 9470M 8GB, Win 10 Pro, & Exchange 2013 & Office 365, 32bit
Remote: Dell XPS Ultrabook with 4GB & Win 10 Pro, Office 365 32bit & Exchange 2013
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

By efficient, I just meant it's faster to hit Ctrl+A, then Ctrl+H from a lookup list view to open a new history window with all the contacts pre-filled.
Solution
Accepted by topic author jnpurdy
‎12-08-2016 05:03 AM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

Hi John,

For these types of outbound email volumes, I would strongly recommend using an emarketing platform like Act emarketing to create or import templates, send out the messages from external mail servers, manage deliverability, avoid spam classification and handle reporting and history recording back into Act.

Mail Merge by nature is not particularly well suited for sending emails to more than a few tens of recipients. I know there are a couple issues with the functionality of Act Mail Merges that are also limiting right now (these are high on the to-fix list), but I would advise you consider changing your approach to sending out these numbers of emails to gain some pretty worthwhile benefits.
Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

If your note regarding the sent email is less than 254 Chars long I would suggest creating a new field called sent emails (254 chars) and make sure it is also ticked create history. Now you can use Edit Replace to update the lookup in the new field and it will also add to the history along with any single emails or closed activity so you can see all communication in one place and also view the last email sent from the new field. I think you will find updating the records much quicker using this option so worth a try.

Bronze Contributor
Posts: 1,393
Country: USA

Re: Better Way To Add History To Large Group Of Contacts

[ Edited ]

An excellent recommendation and I see no reason why Last Results couldn't be used for the same thing.

John Purdy
ACT! Premium 2016 (V. 18)
Main: HP 9470M 8GB, Win 10 Pro, & Exchange 2013 & Office 365, 32bit
Remote: Dell XPS Ultrabook with 4GB & Win 10 Pro, Office 365 32bit & Exchange 2013
Bronze Elite Contributor
Posts: 1,409
Country: United_Kingdom

Re: Better Way To Add History To Large Group Of Contacts

Agreed if last results field is not already in use would work just as well.