Welcome to Forums
Sign in
|
Join
|
Help
|
Forums
Search
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Animal Welfare
Associations
Fundraising
Constituent Relationship Management
Financial Management
Education Administration
Website Management
Direct Marketing
Ticketing
Consulting Services
Blackbaud Interactive
Training
Data Enrichment Services
Blackbaud OnDemand
Custom Report Solutions
Staffing Solutions
Maintenance
Disclaimer
Donor Acquisition
Prospect Research
Performance Benchmarking
Data Enrichment Services
Higher Education
Human Services
Healthcare
K-12 Schools
Arts & Cultural
Faith-Based
Foundations
Environmental
Video Interviews
Alerts
Knowledgebase
FAQs
Case Central
Downloads
Forums
Blogs
Support Newsletters
User Guides
System Recommendations
Blackbaud Conferences
Blackbaud Delivers
Target User Forum
Web Seminars
User Groups
Industry Events
Regional Seminars
Who We Are
Contact Us
Careers
Blogs
Press Room
Philanthropy
Nonprofit Resources
Partners
Investor Relations
PCI Compliance
Home
Blogs
Forums
Photos
Downloads
Search
More Search Options
Page 1 of 5 (47 items) 1
2
3
4
5
Next >
Re: Copy and Paste from Excel into a query
T
h
e
r
e
&
#
3
9
;
s
a
t
h
r
e
a
d
o
n
t
h
e
B
l
a
c
k
b
u
s
s
i
t
e
a
l
l
a
b
o
u
t
t
h
i
s
,
a
n
d
i
s
V
E
R
Y
u
s
e
f
u
l
:
h
t
t
p
:
/
/
w
w
w
.
b
l
a
c
k
b
u
s
.
o
r
g
/
f
o
r
u
m
/
q
u
e
r
y
-
i
m
p
o
r
t
-
e
x
p
o
r
t
/
5
0
3
9
-
c
o
p
y
-
p
a
s
t
e
-
i
n
f
o
r
m
a
t
i
o
n
-
i
n
t
o
-
r
a
i
s
e
r
s
-
e
d
g
e
-
q
u
e
r
y
.
h
t
m
l
T
h
a
n
k
s
L
e
e
Posted to
Data Entry
(Forum)
by
Lee Harrison
on 09-17-2009
Re: Creating an Output Query through Import
T
h
a
t
s
o
l
u
t
i
o
n
n
u
m
b
e
r
i
s
B
B
1
2
4
7
6
6
.
I
d
o
n
&
#
3
9
;
t
k
n
o
w
i
f
y
o
u
&
#
3
9
;
v
e
s
e
e
n
t
h
i
s
t
h
r
e
a
d
,
b
u
t
i
t
a
l
s
o
E
X
T
R
E
M
E
L
Y
u
s
e
f
u
l
h
t
t
p
:
/
/
w
w
w
.
b
l
a
c
k
b
u
s
.
o
r
g
/
f
o
r
u
m
/
q
u
e
r
y
-
i
m
p
o
r
t
-
e
x
p
o
r
t
/
5
0
3
9
-
c
o
p
y
-
p
a
s
t
e
-
i
n
f
o
r
m
a
t
i
o
n
-
i
n
t
o
-
r
a
i
s
e
r
s
-
e
d
g
e
-
q
u
e
r
y
.
h
t
m
l
T
h
a
n
k
s
L
e
e
&
n
b
s
p
;
Posted to
Administration and Configuration
(Forum)
by
Lee Harrison
on 09-17-2009
Re: Test Gift Aid Report
H
i
J
o
n
a
t
h
a
n
,
Y
e
p
,
v
e
r
y
e
a
s
y
t
o
d
o
.
R
u
n
t
h
e
R
6
8
a
s
y
o
u
w
o
u
l
d
t
h
e
r
e
a
l
t
h
i
n
g
,
i
n
c
l
u
d
i
n
g
p
u
t
t
i
n
g
i
n
a
c
l
a
i
m
n
u
m
b
e
r
(
I
d
o
n
&
#
3
9
;
t
t
h
i
n
k
y
o
y
u
c
a
n
r
u
n
i
t
a
t
a
l
l
w
i
t
h
o
u
t
d
o
i
n
g
t
h
a
t
)
a
n
d
t
h
e
n
a
f
t
e
r
r
u
n
n
i
n
g
i
t
i
t
w
i
l
l
a
s
k
i
f
y
o
u
w
a
n
t
t
o
u
p
d
a
t
e
a
l
l
r
e
c
o
r
d
s
w
i
t
h
t
h
a
t
c
l
a
i
m
n
u
m
b
e
r
.
S
a
y
n
o
.
T
h
a
t
&
#
3
9
;
s
i
t
e
v
e
r
y
t
h
i
n
g
w
i
l
l
r
e
m
a
i
n
u
n
t
o
u
c
h
e
d
.
H
o
p
e
t
h
a
t
m
a
k
e
s
.
.
.
Posted to
The Raiser's Edge
(Forum)
by
Lee Harrison
on 09-03-2009
Re: Using different letterhead in a conditional merge
A
s
f
a
r
a
s
I
&
#
3
9
;
m
a
w
a
r
e
,
i
f
y
o
u
h
a
v
e
h
a
v
e
p
r
i
n
t
l
e
t
t
e
r
1
i
f
&
n
b
s
p
;
a
m
o
u
n
t
&
l
t
;
&
l
t
;
l
e
s
s
t
h
a
n
$
2
5
&
g
t
;
&
g
t
;
a
n
d
t
h
e
n
p
r
i
n
t
l
e
t
t
e
r
2
i
f
&
n
b
s
p
;
a
m
o
u
n
t
&
l
t
;
&
l
t
;
l
e
s
s
t
h
a
n
&
n
b
s
p
;
$
5
0
0
&
g
t
;
&
g
t
;
a
n
d
t
h
e
n
p
r
i
n
t
l
e
t
t
e
r
3
i
f
&
n
b
s
p
;
a
m
o
u
n
t
&
l
t
;
&
l
t
;
l
e
s
s
t
h
a
n
$
2
,
5
0
0
&
g
t
;
&
g
t
;
T
h
e
n
i
t
w
i
l
l
w
o
r
k
i
n
t
h
e
s
a
m
e
w
a
y
.
e
g
a
n
y
d
o
n
a
t
i
o
n
b
e
t
w
e
e
n
$
2
5
a
n
d
$
4
9
9
w
i
l
l
g
e
t
l
e
t
t
e
r
2
.
.
.
.
Posted to
Export/Mail/Reports
(Forum)
by
Lee Harrison
on 09-02-2009
Re: Aliases
H
i
R
o
s
e
,
Y
o
u
c
a
n
&
#
3
9
;
t
t
i
c
k
/
u
n
t
i
c
k
t
h
e
c
h
e
c
k
a
l
i
a
s
e
s
b
o
x
u
n
t
i
l
y
o
u
p
o
p
u
l
a
t
e
o
n
e
o
f
t
h
e
f
i
e
l
d
s
.
A
s
s
o
o
n
a
s
y
o
u
p
u
t
a
s
i
n
g
l
e
c
h
a
r
a
c
t
e
r
i
n
a
f
i
e
l
d
(
&
#
3
9
;
n
a
m
e
&
#
3
9
;
f
o
r
e
x
a
m
p
l
e
)
t
h
e
n
y
o
u
s
h
o
u
l
d
h
a
v
e
t
h
e
o
p
t
i
o
n
t
o
t
i
c
k
t
h
e
a
l
i
a
s
e
s
b
o
x
.
H
o
p
e
t
h
i
s
h
e
l
p
s
(
a
n
d
p
r
o
v
e
s
t
r
u
e
)
L
e
e
Posted to
Data Entry
(Forum)
by
Lee Harrison
on 08-24-2009
Re: Adding a Standing Order/Direct Debit Gift - is this a good way to do it?
H
i
F
i
o
n
a
,
&
n
b
s
p
;
R
a
t
h
e
r
t
h
a
n
u
s
e
p
l
e
d
g
e
,
y
o
u
&
#
3
9
;
d
b
e
b
e
t
t
e
r
o
f
f
u
s
i
n
g
r
e
c
u
r
r
i
n
g
g
i
f
t
.
T
h
e
n
,
u
n
d
e
r
p
a
y
m
e
t
h
o
d
y
o
u
c
a
n
s
p
e
c
i
f
y
w
h
e
t
h
e
r
i
t
&
#
3
9
;
s
a
s
t
a
n
d
i
n
g
o
r
d
e
r
o
r
d
i
r
e
c
t
d
e
b
i
t
.
O
n
c
e
y
o
u
h
a
v
e
d
o
n
e
t
h
a
t
e
a
c
h
t
i
m
e
y
o
u
a
d
d
a
n
e
w
g
i
f
t
f
o
r
t
h
a
t
p
e
r
s
o
n
R
E
w
i
l
l
a
s
k
i
f
y
o
u
w
a
n
t
t
o
a
d
d
i
t
a
s
a
&
#
3
9
;
r
e
c
u
r
r
i
n
g
g
i
f
t
p
a
y
c
a
s
h
&
#
3
9
;
(
y
o
u
m
i
g
h
t
h
a
v
e
t
o
t
i
c
k
a
.
.
.
Posted to
Higher Education
(Forum)
by
Lee Harrison
on 08-03-2009
Re: New to using events module
I
w
o
u
l
d
g
l
o
b
a
l
l
y
a
d
d
i
n
v
i
t
e
e
s
t
o
a
n
e
v
e
n
t
a
n
d
c
h
e
c
k
t
h
e
b
o
x
t
h
a
t
s
a
y
s
u
p
d
a
t
e
n
u
m
b
e
r
i
n
v
i
t
e
d
.
W
h
e
t
h
e
r
o
r
n
o
t
y
o
u
w
a
n
t
t
o
j
u
s
t
a
d
d
a
t
t
e
n
d
e
e
s
o
r
a
l
l
t
h
a
t
w
e
r
e
i
n
v
i
t
e
d
d
e
p
e
n
d
s
o
n
h
o
w
y
o
u
w
a
n
t
t
o
u
s
e
t
h
e
i
n
f
o
r
m
a
t
i
o
n
.
I
f
y
o
u
&
#
3
9
;
l
l
w
a
n
t
t
o
d
o
e
v
e
n
t
a
n
a
l
y
s
i
s
d
o
w
n
t
h
e
l
i
n
e
t
h
e
n
i
t
w
o
u
l
d
p
r
o
b
a
b
l
y
u
s
e
f
u
l
t
o
a
d
d
a
l
l
t
h
a
t
w
e
r
e
i
n
v
i
t
e
d
a
n
d
t
h
e
n
m
a
r
k
t
h
o
s
e
t
h
a
t
.
.
.
Posted to
Optional Modules
(Forum)
by
Lee Harrison
on 06-30-2009
Re: Importing Event Information from Excel into RE7
H
i
C
a
r
l
,
G
e
n
e
r
a
l
l
y
s
p
e
a
k
i
n
g
,
i
m
p
o
r
t
i
n
g
f
r
o
m
a
s
p
r
e
a
d
s
h
e
e
t
i
n
t
o
R
E
i
s
b
e
s
t
d
o
n
e
w
i
t
h
a
C
S
V
.
Y
o
u
w
i
l
l
a
l
s
o
n
e
e
d
t
h
e
c
o
r
r
e
c
t
h
e
a
d
e
r
s
f
o
r
e
a
c
h
c
o
l
u
m
n
,
w
h
i
c
h
c
a
n
b
e
f
o
u
n
d
b
y
g
o
i
n
g
t
o
t
h
e
h
e
l
p
t
a
b
i
n
R
E
,
c
l
i
c
k
i
n
g
o
n
T
h
e
R
a
i
s
e
r
&
#
3
9
;
s
E
d
g
e
H
e
l
p
T
o
p
i
c
s
,
a
n
d
t
h
e
n
t
y
p
i
n
g
i
n
I
m
p
o
r
t
T
a
b
l
e
s
L
i
s
t
i
n
t
h
e
s
e
a
r
c
h
f
i
e
l
d
.
U
n
f
o
r
t
u
n
a
t
e
l
y
t
h
e
h
e
a
d
e
r
s
a
r
e
n
&
#
3
9
;
t
t
h
e
.
.
.
Posted to
Implementation/Conversion
(Forum)
by
Lee Harrison
on 06-23-2009
Re: Wrong Event Info is Exporting
H
i
E
r
i
n
,
I
&
#
3
9
;
v
e
n
e
v
e
r
r
e
a
l
l
y
b
e
e
n
a
b
l
e
t
o
f
i
l
t
e
r
e
v
e
n
t
s
p
r
o
p
e
r
l
y
b
y
u
s
i
n
g
s
t
a
r
t
a
n
d
&
n
b
s
p
;
e
n
d
d
a
t
e
s
.
A
l
t
h
o
u
g
h
i
t
&
#
3
9
;
s
n
o
t
a
b
r
i
l
l
i
a
n
t
s
o
l
u
t
i
o
n
,
&
n
b
s
p
;
a
q
u
i
c
k
f
i
x
f
o
r
a
o
n
e
-
o
f
f
r
e
p
o
r
t
w
o
u
l
d
b
e
t
o
c
h
a
n
g
e
t
h
e
t
y
p
e
o
f
e
v
e
n
t
t
o
s
o
m
e
t
h
i
n
g
u
n
i
q
u
e
(
e
g
t
h
e
e
v
e
n
t
I
D
)
a
n
d
t
h
e
n
i
n
t
h
e
e
x
p
o
r
t
f
i
l
t
e
r
o
n
t
h
a
t
e
v
e
n
t
t
y
p
e
.
T
h
a
n
k
s
L
e
e
Posted to
Export/Mail/Reports
(Forum)
by
Lee Harrison
on 06-17-2009
Re: How to query for all alumni who are children of alumni
H
i
A
i
m
e
e
,
I
&
#
3
9
;
v
e
j
u
s
t
t
r
i
e
d
t
h
i
s
a
n
d
i
t
s
e
e
m
e
d
t
o
w
o
r
k
:
F
i
r
s
t
o
f
a
l
l
r
u
n
a
R
e
l
a
t
i
o
n
s
h
i
p
Q
u
e
r
y
a
n
d
u
n
d
e
r
t
h
e
C
o
n
s
t
i
t
u
e
n
t
n
o
d
e
c
h
o
o
s
e
c
o
n
s
t
i
t
u
e
n
t
c
o
d
e
=
C
o
l
l
e
g
e
G
r
a
d
u
a
t
e
a
n
d
t
h
e
n
u
n
d
e
r
t
h
e
I
n
d
i
v
i
d
u
a
l
n
o
d
e
c
l
i
c
k
o
n
c
o
n
s
t
i
t
u
e
n
t
c
o
d
e
=
C
o
l
l
e
g
e
G
r
a
d
u
a
t
e
A
N
D
R
e
l
a
t
i
o
n
s
h
i
p
C
o
d
e
=
O
n
e
o
f
F
a
t
h
e
r
/
M
o
t
h
e
r
/
P
a
r
e
n
t
.
.
.
(
d
e
p
e
n
d
i
n
g
o
n
h
o
w
y
o
u
c
o
d
e
p
a
r
e
n
t
s
)
.
T
h
a
t
.
.
.
Posted to
Query
(Forum)
by
Lee Harrison
on 05-18-2009
Page 1 of 5 (47 items) 1
2
3
4
5
Next >