asked on

ACT 2011 won't export JUST the email address

In ACT 2011, I ask to export the email address and nothing else for a lookup (see screen shot below). The output text file contains first name and last name in addition. I used to do this in ACT 6 all the time but can't get it to work here.

Thanks...
ACT-export-error.jpg

ASKER CERTIFIED SOLUTION

50cal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Helmers

ASKER

Interesting idea... hadn't noticed the separate Export to Excel on the Tools menu. However, unless I'm missing something, this means that every time I want to export just emails, I have to delete all columns from the contact list view, do the export, then rebuild the columns I normally use. Not very practical.

Ahh... but if I leave my contact list view as is and use your export technique, I'll have too much data in Excel. But it's trivial to delete the columns I don't want in Excel. This works.

BTW, back to the export wizard -- any idea why that doesn't work??

Scott

50cal

It seems to work fine in "Sage ACT! Premium 2011 Version 13.0.401.0".

Contact Records
All Contacts
Tab
Export First Record Checked
Remove all but email.

What version are you using and are you choosing the same options?

50cal.

Scott Helmers

ASKER

I have "Sage ACT! Pro 2011 Version 13.0.401.0, Hot Fix 2", which the update function tells me is the latest. You can see exactly what I'm doing in the screen shots below.

Thanks for looking at this...
ACT-export-wizard-screens.jpg

SOLUTION

Mike Lazarus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott Helmers

ASKER

Thanks, Mike. It doesn't look like the issues addressed in the hotfix have anything to do with incorrect data export, but I'll give it a try.

BTW, is it normal that Help>ACT Update doesn't discover available hotfixes?

Scott

50cal

The Update feature in Act is quite temperamental, checking Sage for updates is probably easier.

https://support.sage.co.uk/default.aspx?page=18

50cal.

Scott Helmers

ASKER

Thanks, 50Cal.

BTW, is there anything wrong with the settings in the sequence of export wizard dialogs above? Any reason why those settings should give me the results in the first posting above?

Mike Lazarus

Hotfixes aren't ever delivered by Help | Update
The reason for this is that all users must be on the same build and an admin wouldn't want users (especially remote) to apply an update before they are ready to apply it for all users.

Scott Helmers

ASKER

Thanks, guys. I'll close the question now but I am still curious to know whether I should file a bug report with Sage based on the wizard screens above. Those settings produce a file that contains first name, last name, and email address as shown at the top of this question.