Excel Client:Mail Merge Wizard: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
← Older edit
VisualWikitext
No edit summary
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 6: Line 6:
{| style=cellspacing="1" cellpadding="5" border="0" width={{{breite|100%}}}
{| style=cellspacing="1" cellpadding="5" border="0" width={{{breite|100%}}}
|-
|-
|'''Step 1:'''
|'''Step 1:'''
[[image:EC_Mail Merge Wizard01.jpg|thumb]]
|In the first step you can either define a new mail merge or select a previously defined and saved mail merge.
|In the first step you can either define a new mail merge or select a previously defined and saved mail merge.


Line 15: Line 14:
|-
|-
|'''Step 2:'''
|'''Step 2:'''
[[image:EC_Mail Merge Wizard02.jpg|thumb]]
[[image:EC_Mail Merge Wizard03.jpg|thumb]]
[[image:EC_Mail Merge Wizard04.jpg|thumb]]
|The second step consists of two actions if the option “Create a new definition” was selected in Step 1.
|The second step consists of two actions if the option “Create a new definition” was selected in Step 1.
#Select the cell of the Excel worksheet that contains the filter cell (ElemSelect) which you want to use as your mail merge. Click on the [[Excel_Client:ElemSelect|ElemSelect]] button to activate cell selection.  
#Select the cell of the Excel worksheet that contains the filter cell ([[Excel_Client:ElemSelect|ElemSelect]]) which you want to use as your mail merge. Click on the [[Excel_Client:ElemSelect|ElemSelect]] button to activate cell selection.  
#Next, select the desired cell and confirm your selection by pressing the Enter key on your keyboard
#Next, select the desired cell and confirm your selection by pressing the Enter key on your keyboard
#If the selected cell is valid as the basis of a mail merge, a dropdown list containing elements will appear. Use the dropdown list to select the elements to be included in the mail merge
#If the selected cell is valid as the basis of a mail merge, a dropdown list containing elements will appear. Use the dropdown list to select the elements to be included in the mail merge
Line 28: Line 22:


To save your settings, click the [[image:Icon_Speichern.jpg‎]] button. If the settings you entered are valid, a dialogue will appear in which you can name your definition. Assign a name to your definition and confirm by clicking “OK”. The name of this definition will now be available in Step 1 in the “Use saved definition” dropdown list. To ensure that the definition remains available after you reopen the report, please save your workbook after completing the mail merge.  
To save your settings, click the [[image:Icon_Speichern.jpg‎]] button. If the settings you entered are valid, a dialogue will appear in which you can name your definition. Assign a name to your definition and confirm by clicking “OK”. The name of this definition will now be available in Step 1 in the “Use saved definition” dropdown list. To ensure that the definition remains available after you reopen the report, please save your workbook after completing the mail merge.  
#Wählen Sie die Zelle des Excel Arbeitsblattes, welche die Filterzelle ([[Excel_Client:ElemSelect|ElemSelect]]) beinhaltet, die als Serie herangezogen werden soll. Klicken Sie hiefür auf die Schaltfläche, um die Zellselektion zu aktivieren. Selektieren Sie nun die gewünschte Zelle und bestätigen Sie die Selektion mit der Eingabetaste (Enter).
#Ist die selektierte Zelle als Seriendruckbasis gültig, erscheint eine Elementselektions-Kombinationslistenfeld. Durch diese können Sie jene Elemente auswählen, welche die Serie beinhalten soll.


|-
|-
|'''Step 3:'''
|'''Step 3:'''
[[image:EC_Mail Merge Wizard05.jpg|thumb]]
|In Step 3 you can choose the output type.
 
|Im Schritt drei besteht die Möglichkeit der Auswahl des Ausgabetyps.


#'''Ausgabe in Arbeitsmappe''': Dies bedeutet, dass Pro Element der Serie ein Arbeitsblatt in einer Arbeitsmappe gespeichert wird. Um diese Art der Ausgabe bestätigen zu können, müssen die den Namen und den Speicherort der Datei angeben, in welcher die Arbeitsblätter eingefügt werden sollen. Die Auswahl des Speicherorts definieren Sie mit einem Klick auf die Schaltfläche [[image:Icon_Speichern.jpg‎]].
#'''Workbook output''': This means that a worksheet will be saved in a workbook for each element in the merge. To confirm this output type, you must state the name and location of the file in which you want to insert the worksheets. You can specify the location by clicking on the [[image:Icon_Speichern.jpg‎]] button.
#'''Ausgabe in Arbeitsmappen''': Pro Element der Serie wird eine Arbeitmappe erstellt. Diese beinhaltet ein Arbeitsblatt mit den Werten des entsprechenden Serienelements. Um diese Art der Ausgabe bestätigen zu können, müssen Sie das Verzeichnis angeben, in welches die Arbeitsmappen der Serie gespeichert werden sollen. Die Auswahl des Verzeichnisses definieren Sie durch einen Klick auf die Schaltfläche [[image:Icon_Speichern.jpg‎]].
#'''Multiple workbook output''': A workbook will be created for each element in the merge. The workbook will contain a worksheet with the values of the mail merge element. To confirm this output type, you must specify the directory in which the workbooks for the mail merge will be saved. You can specify the directory by clicking on the [[image:Icon_Speichern.jpg‎]] button.  
#'''Ausgabe am Drucker''': Für jedes Element der Serie wird das Arbeitsblatt am Drucker ausgegeben. Hier wird jener Drucker verwendet, welcher als Standarddrucker in Microsoft Excel definiert ist. Achtung: Vergewissern Sie sich vorher, dass der Druckbereich nach Ihren Vorstellungen definiert ist.
#'''Printer output''': The worksheet will be printed for each mail merge element. The target printer will be the printer that is selected as the default printer in Microsoft Excel. Important: Before printing, please make sure that you have selected the correct print range.


Sind die Einstellungen komplett, kann durch einen Klick auf „Fertigstellen“ der Erstellung der Serie gestartet werden. Durch „Weiter >“ gelangen Sie zu Schritt vier, der Zusammenfassung.
When you have entered all the necessary settings, click “Finish” to start the mail merge. Click “Next >” to go to Step 4 (the summary).
|-
|-
|'''Step 4:'''
|'''Step 4:'''
[[image:EC_Mail Merge Wizard08.jpg|thumb]]
|Step 4 is the summary, where you can review your chosen settings before starting the mail merge. If all your settings are correct, click “Finish” to start the mail merge.
|Schritt vier ist die Zusammenfassung, in welcher Sie auf einen Blick die von Ihnen gewählten Einstellungen nochmals prüfen können. Durch einen Klick auf die Schaltfläche „Fertigstellen“, wird die Erstellung der Serie gestartet.
|}
|}


Latest revision as of 10:25, 5 May 2011

The Mail Merge Wizard helps you to create a mail merge. The various steps of the Mail Merge Wizard will not be available unless the settings in the previous section are valid. In other words, the “Next” button will not be active until you have entered the correct settings.

The Mail Merge Wizard consists of four steps:


Step 1: In the first step you can either define a new mail merge or select a previously defined and saved mail merge.

If no mail merge was previously created, the option to select a saved mail merge will not be available.

Confirm your selection by clicking “Next”.

Step 2: The second step consists of two actions if the option “Create a new definition” was selected in Step 1.
  1. Select the cell of the Excel worksheet that contains the filter cell (ElemSelect) which you want to use as your mail merge. Click on the ElemSelect button to activate cell selection.
  2. Next, select the desired cell and confirm your selection by pressing the Enter key on your keyboard
  3. If the selected cell is valid as the basis of a mail merge, a dropdown list containing elements will appear. Use the dropdown list to select the elements to be included in the mail merge

Confirm your selection by clicking “Next”.

To save your settings, click the button. If the settings you entered are valid, a dialogue will appear in which you can name your definition. Assign a name to your definition and confirm by clicking “OK”. The name of this definition will now be available in Step 1 in the “Use saved definition” dropdown list. To ensure that the definition remains available after you reopen the report, please save your workbook after completing the mail merge.

Step 3: In Step 3 you can choose the output type.
  1. Workbook output: This means that a worksheet will be saved in a workbook for each element in the merge. To confirm this output type, you must state the name and location of the file in which you want to insert the worksheets. You can specify the location by clicking on the button.
  2. Multiple workbook output: A workbook will be created for each element in the merge. The workbook will contain a worksheet with the values of the mail merge element. To confirm this output type, you must specify the directory in which the workbooks for the mail merge will be saved. You can specify the directory by clicking on the button.
  3. Printer output: The worksheet will be printed for each mail merge element. The target printer will be the printer that is selected as the default printer in Microsoft Excel. Important: Before printing, please make sure that you have selected the correct print range.

When you have entered all the necessary settings, click “Finish” to start the mail merge. Click “Next >” to go to Step 4 (the summary).

Step 4: Step 4 is the summary, where you can review your chosen settings before starting the mail merge. If all your settings are correct, click “Finish” to start the mail merge.
Retrieved from "https://copsupport.coplanner.com/help11_en/index.php?title=Excel_Client:Mail_Merge_Wizard&oldid=12492"