ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Create an import file for Constant Contact by adding Area to a PDB export.
3
4
Tabs:
5
6
InstructionsThis sheet
7
AreasSource 1: The mapping of branches to areas. Update only if these relationships change.
8
participants-databaseSource 2: Import of .csv file exported from PDB
9
Constant ContactThe results. Note the formulas in cells A2, B2, and C2.
10
11
Procedure:
12
13
Export a .csv file from PDB WITHOUT headers, specifying the year.
14
Import it into the participants-database tab
15
Rename the tab to participants-database.
16
The Constant Contact tab will contain the merged information for import into Constant Contact.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100