Show theme settings Shopping cart Download trialFree Trial
Calibri
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Mail Merge

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Steven Buchanan
Laura Callahan
Nancy Davolio
Anne Dodsworth
Andrew Fuller
Robert King
Janet Leverling
Margaret Peacock
Michael Suyama
Position:
Sales Manager
Inside Sales Coordinator
Sales Representative
Sales Representative
Vice President, Sales
Sales Representative
Sales Representative
Sales Representative
Sales Representative
Birth Date:
3/4/1977
1/9/1980
12/8/1970
1/27/1988
2/19/1974
5/29/1982
8/30/1985
9/19/1959
7/2/1985
Hire Date:
Homephone:
(71) 555-4848
(206) 555-1189
(206) 555-9857
(71) 555-4444
(206) 555-9482
(71) 555-5598
(206) 555-3412
(206) 555-8122
(71) 555-7773
Address:
14 Garrett Hill London UK
4726 - 11th Ave. N.E. Seattle USA
507 - 20th Ave. E. Apt. 2A Seattle USA
7 Houndstooth Rd. London UK
908 W. Capital Way Tacoma USA
Edgeham Hollow Winchester Way London UK
722 Moss Bay Blvd. Kirkland USA
4110 Old Redmond Rd. Redmond USA
Coventry House Miner Rd. London UK
About:
Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.
Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.
Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.
Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.
Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.
Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993.
Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.
Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.
Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish.
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK


The Mail Merge functionality provided by the DevExpress ASP.NET MVC Spreadsheet enables you to automatically generate a set of documents based on a common template and fill each document with unique data values retrieved from a data source. This feature can be useful for a variety of business requirements, such as personalizing letters, and composing catalogs and reports.

To perform a mail merge, you need a template and a data source.

A template is a spreadsheet document that contains static information (which is the same for all resulting documents) and mail merge fields. A mail merge field is a placeholder in which a value from the specified data source field will appear in a merged document. To insert fields into template cells, use the following special functions in cell formulas: FIELD and FIELDPICTURE.

A data source (Model) contains data that will be merged into fields in a template to create merged documents.

Within a template, you can choose a mail merge mode specifying how the result of the mail merge should be generated. The mail merge mode is specified programmatically at the template workbook level, by setting a specific defined name ("MAILMERGEMODE") to a particular string constant ("Worksheets" or "OneWorksheet").

  • "OneWorksheet" (Single Sheet) - Merged ranges for all data source records are inserted one after another (vertically or horizontally, depending on the document orientation) into a single worksheet. This mode is used by default.
  • "Worksheets" (Multiple Sheets) - The merged range for each data source record is inserted into a separate worksheet in a single workbook.

Note that by default, the "MAILMERGEMODE" defined name does not exist in a template workbook and the "Single Sheet" mode is used.

To initialize the mail merge process, use the PerformMailMerge method of the Spreadsheet extension. This method accepts a set of parameters (which specify the path to a template, a data source object, the mail merge mode and etc.) and generates resulting documents containing the merged information (if the "Single Sheet" or "Multiple Sheets" mail merge mode is used, a single workbook is processed).

In this demo, we illustrate the merging of images along with personal information for contacts from the Northwind database's Employees table.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
The source code files for this demo are installed (by default) in the following directory:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos