100 likes | 264 Views
INTRODUCTION to MICROSOFT EXCEL (Mail List). OUR USES mail lists (especially Christmas card lists); engagement and wedding invitation mail out ;. MAILING LISTS. What info is required Title Surname Given Name. Initial(s) Address 6 Suburb 7 State Postcode 9. Country.
E N D
OUR USES mail lists (especially Christmas card lists); engagement and wedding invitation mail out;
MAILING LISTS What info is required • Title • Surname • Given Name
Initial(s) Address 6 Suburb 7 State Postcode 9. Country
How to Create List • 1. Open Excel • 2. Cell A1 – Title • 3. Complete Row 1 with “headings” • 4. Format Row 1 • Bold • Centre
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