If a field does not appear in either list it means that field cannot be exported. The fields in the right side of the window repre sent all the fields you are currently seeing in the List View the fields on the left side represent all the fields that are available for inclusion on the List View including any customized fields you may have created. A dialog window similar to the one you see below will open. Ad d a column: Simply right-click smack dab in the middle of the List View and chose Customize Columns.Reorder the columns in a list view: Hold down your mouse cursor on a column header and drag it to a new location.There are some easy ways to organize your data prior to the Excel export. The data displayed on the Act! list view will be exported to Excel in the same exact order. The Contact List view appears with the Group or Company members displayed Customize the List Viewīefore you export to Excel, you’ll want to customize the columns on the List View.
Sage act 2013 download how to#
You probably already know how to create a Lookup in Act! to find contact records, but you might not know that you can create a Lookup to find the members of a Group or Company by simply right-clicking the Group or Company name in the list view and choosing Create Lookup.
With Act!, exporting Your Act! Data to Excel is as Easy as 1,2,3: For example, you may be using Act! 2009 but your Office version is 2010 or 2013.