INTRODUCTION to MICROSOFT EXCEL (Mail List)

1
INTRODUCTION to MICROSOFT EXCEL (Mail List)
2

• OUR USES
• mail lists (especially Christmas card lists)
• engagement and wedding invitation mail out

3
MAILING LISTS

• What info is required
• Title
• Surname
• Given Name

4

• Initial(s)
• Address
• 6 Suburb
• 7 State
• Postcode
• 9. Country

5
How to Create List

• 1. Open Excel
• 2. Cell A1 Title
• 3. Complete Row 1 with headings
• 4. Format Row 1
• Bold
• Centre

6
Insert DetailTips Tricks

• SAVE SAVE SAVE!!!
• My Data Sources (in My Documents) quick link in
  Mail Merge
• Be Consistent
• Use Normal Punctuation Conventions
• Format Spreadsheet

7
Widen ColumnsApply BordersLandscape
8
PRACTICE PRACTICE PRACTICE
9
(No Transcript)