Mail Merge is one of the most useful facilties within the MS office suite of programs.
It is possible to mail merge from Excel into Outlook and Access into Excel as just two examples.
I often start with my data sitting in Excel as a single worksheet. Take for example a customer address list. A list of prospects or customers can be entered as separate rows into Excel with clear column headings eg Customer name, address 1, post code etc.
You can then for example import this list into Outlook as a new set of Outlook contacts or indeed as a new Access table to start off your database.
Excel worksheets are also particularly useful for compiling form letters and producing mailing labels for customers.
They’re real time savers!!
