Latest posts by techwriter (see all)
- 3 Ways to Add Copyright Free Images to Your Blogs, Books and Documents - September 19, 2016
- How to Delete All Hyperlinks in a MS #Word Document through VBA Macro - September 1, 2016
- How to View a List of All Open MS Word Documents through VBA Macro - August 31, 2016
In another post I’ve explained how MS Word 2010 mail merge works and why do we need a database TABLE for it.
The question is, what kind of database tables would MS Word 2010 accept?
Answer: quite a few.
You can, for example, create a MS EXCEL database table. That would be perfect.
Word accepts MS ACCESS databases tables as well.
You can use a simple Word table that displays the VARIABLE names on the first row and individual records on the following rows.
|Bob||Smith||Saturday||11 a.m.||South Room|
|Jane||Doe||Monday||2 p.m.||North Office|
And lastly, you can use any text editor including the Notepad to create a DELIMITED TEXT FILE in which the variables (data fields) are separated from one another by a comma, tab character, with each data record separated from one another by a HARD RETURN (i.e., each record on a new line).
Bob,Smith,Saturday,11 a.m.,South Room
Jane,Doe,Monday,2 p.m.,North Office