File: sample-mail-merge.tex

package info (click to toggle)
texlive-extra 2014.20141024-1
  • links: PTS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 2,016,484 kB
  • ctags: 21,582
  • sloc: perl: 140,144; python: 16,926; makefile: 12,969; sh: 9,285; ansic: 3,415; java: 3,090; csh: 2,987; xml: 1,050; lisp: 630; ruby: 487; lex: 358; tcl: 142; sed: 36; pascal: 25; cpp: 18; awk: 10; haskell: 5
file content (21 lines) | stat: -rw-r--r-- 650 bytes parent folder | download | duplicates (7)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 % This file is public domain.
\documentclass{letter}

\usepackage{datatool}

\DTLloaddb{data}{sample-student-records.csv}

\begin{document}
\begin{DTLenvforeach*}{data}{\Title=Title,\FirstName=First Name,\Surname=Surname,\AssignmentI=Assignment 1,\AssignmentII=Assignment 2,\AssignmentIII=Assignment 3,\Address=Address}
\begin{letter}{\Title\space\FirstName\space\Surname\\\Address}
\opening{Dear \Title~\Surname}

\DTLmeanforall{\Score}{\AssignmentI,\AssignmentII,\AssignmentIII}
\DTLround{\Score}{\Score}{0}\DTLclip{\Score}{\Score}%
You were awarded a mark of \Score\%.

\closing{Yours Sincerely}
\end{letter}

\end{DTLenvforeach*}
\end{document}