Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
spread sheet info onto mailing labels
- Thread starter raftree
- Start date
The easiest way I can think of is to link the spreadsheet into Access. This will enable you to treat the spreadsheet as an Access table. Access has a report wizard which will create the mailing labels for you pretty easily.
Let me know if you need details.
Kathryn
Let me know if you need details.
Kathryn
Storyteller
Instructor
Hello Raftree,
You can use the Excel worksheet as the Data Source instead of going through Access.
Step 2 of Mail Merge
Select: "Open Data Source"
Change "Files of Type" to Excel
Select the Excel File
The remainder is inserting the Merge fields into your Word Document. The column headers in your Excel Spreadsheet will be the Field Names.
This should work.
On thought, why not import this list into "Contacts" in Outlook and then use "Address Book" as your data source for a mail merge.
If you are using Outlook 2000 there are some neat tricks that I can tell you about.
Good Luck,
Michael
You can use the Excel worksheet as the Data Source instead of going through Access.
Step 2 of Mail Merge
Select: "Open Data Source"
Change "Files of Type" to Excel
Select the Excel File
The remainder is inserting the Merge fields into your Word Document. The column headers in your Excel Spreadsheet will be the Field Names.
This should work.
On thought, why not import this list into "Contacts" in Outlook and then use "Address Book" as your data source for a mail merge.
If you are using Outlook 2000 there are some neat tricks that I can tell you about.
Good Luck,
Michael
- Status
Similar threads
- Locked
- Question