1
Lesson 6
[
]
Advanced Functions: Utility Menu
[ Learning Outcomes ]
In this lesson, you are going to discover the Advanced Functions that can be performed in the Utility Menu in Sage Pastel Partner Version 12. You will explore the functions and demonstrate the processes.
[ Learning Objectives ]
On completion of this lesson, you will be familiar with: A. Microsoft Office Integration
MS Outlook – Export
MS Excel – Data Analysis
2
A. Microsoft Office Integration
In this section, we will explore how to integrate your Sage Pastel Partner V12 company with Microsoft Office. We will not go into how to use the Microsoft package, since that is outside of the scope of this course. There are many training centres countrywide that offer training on Microsoft to an advanced level. To get the most from the Office integration, it is recommended that you attend one of those courses.
We are going to go through the following areas of Microsoft integration.
MS Outlook – Export;
MS Excel – Data Analysis; and
MS Word – Create and Manage Letters and Labels.
The Mail Merge feature is covered in another section of this manual.
[ MS Outlook Integration ]
You are able to export all your Customer and/or Supplier email addresses from Sage Pastel Partner V12 to your MS Outlook address book. This is a very useful tool for adding contacts from Sage Pastel Partner V12 to your Outlook contacts.
3
2. In the screen that displays, you will be asked to select which contacts you want to export.
3. Once you have selected the range, click on Next and you will be prompted to select how you would like to have the contacts added to your Outlook address book.
4
5. When Sage Pastel Partner V12 has finished exporting the contacts, the last screen will appear. Click on Finish to close the Assistant.
[ MS Excel – Data Analysis ]
You are able to create complex reports in MS Excel using your Sage Pastel Partner V12 data. When you integrate Sage Pastel Partner V12 with MS Excel, you will send data from Sage Pastel Partner V12 to an MS Excel spread sheet. You can then format your data and create graphs from your data in MS Excel.
5
2. Select Next and the Main Export Criteria screen will open. In this screen, you will select the general information that you want to export, and the select Next.
3. In the next screen, you will select more specific information. You are also able to add a broad filter to this information, based on the field that you are on. For example, you are able to select only one category, or a range of codes.
6
5. Again in the next screen, you will select more detail on the information that you would like to export. The fields available will depend on your previous selections.
6. Select the final specific for your export and click on Next.
7
8. The Process Finished screen will appear, with details on how to find your spreadsheet. Click on Finish to close the Assistant.
9. As we mentioned previously, we will not go into the editing of the information in MS Excel, as this is outside the scope of this course.
[ MS Word – Create and manage Letters and Labels ]
The last integration process that we will go through is the merge with MS Word to create letters and labels. If you are not comfortable with the Merge functions in MS Word, it is recommended that you edit the existing documents rather than creating new ones. Alternatively, you could go for training on advanced MS Word features.
8
2. In the Select an Option screen, you will select which task you wish to perform. For this training, we will select to create inventory labels.
9
4. In the next screen, you will be asked to name the document. You will see that there is already an Inventory Labels document in the folder. Do not use the same name, as this will overwrite the existing original file.
5. If you click on the dropdown arrow next to Save in, you will see that Sage Pastel Partner V12 saves your merge documents in the Documents folder inside your company folder. This is done so that when you back up your company, you save a copy of your merge documents as well.
6. Once you have named and saved your document, the Assistant will close and an MS Word document will be minimised in the taskbar. If you open the document, you will see that it is blank, and opens on the Mailings screen.
10
8. Once you have selected the correct paper, you can insert your merge fields by clicking on the drop down in the toolbar. As you can see in the screen below, the inventory fields from Sage Pastel Partner V12 have been added to the list for you to select.
9. As mentioned before, we will not go into detail on how to create the document, as it is outside the scope of this training course.
In this lesson, you learned how to integrate Sage Pastel Partner V12 with the following MS Office programs:
MS Outlook;
MS Excel; and
11 1. Where are your merge documents saved, and why?
