How to do Mail Merge in Excel?
Advanced Mail Merge
- Mail merge is very simple concept. But it is made as very complex process.
- Why MS-Word Mail merge is complex? And what are limitaions?
- Template is in MS-Word. Address lists are in yet another place. Data is in Spreadsheet or
Database. This leads to complex setup.
- You can do only one-to-one field mapping. i.e one customer should have only one record. In
reality one customer will have multiple records.
- And MS-Word mail merge won't support file Attachments. Which is a big show stopper.
- Advanced Mail Merge
- It is very simple process. Design your template in Excel
- Preview mail with outlook.
- Supports File Attachments.
- Mail merge made easy.
- Please watch the above video to see Advanced Mail Merge in action.