Creating Merge (Data/Source Files) with a
Web site Exported Tab Delimited File
Microsoft Word Mail Merge Instructions
After you have created, downloaded and saved your Power Search file:
Launch Excel
Open the (*.tab) file you exported from RBCS.com, you may
have to change the "file of types" to "all files"
You are now at the Import Wizard Steps 1 of 3
Original data type is DELIMITED
File origin is Windows ANSI
Click Next
Select Tab as the delimiters (you may have to deselect comma)
Click Next
Click Finish
Save your file with the (*.xls) extension. (Use whichever version Excel you
are using)
Close the document and Exit Excel.
Launch Word
At a BLANK NEW document
Select Tools
Mail Merge
Create Main document (i.e. Form letters, Mailing labels).
Choose Active window
Choose Get Data
Open Data Source
Change file type to MS Excel worksheets (*.xls)
Select Excel file you saved with the (*.xls) extension
Choose open
Select MS Excel worksheet via DDE (*.xls) This may or may
not appear depending on your Program Setup, Click OK
Select Entire Spreadsheet, Click OK
Setup Main Document (i.e. labels or form letter) by inserting
merge fields in the order you would like them to display in your document.
Merge your document: Tools, Mail Merge
Merge or Query options if you would like to Query your
file before you merge you can do that as well. Then Merge.
Review your merged document for errors before printing.