Solved

How to get data from multiple sheets an in .xlw into mail merge

Posted on 2011-09-14
5
190 Views
Last Modified: 2012-05-12
I have office 2003 and am trying to create a mail merge in publisher from excel.

The excel sheet is in .xlw opposed to .xls - there is no difference that my eye can see but I haven't really dug too deep.

When I try to mail merge into publisher, it's asking for a specific database type and won't accept the .xlw or any other format I am able to "Save as" from excel.

The excel workbook has multiple pages and I'd like to be able to pull from them independently, as online instructions say I can.

I was getting a verbose error message that after research, had me install a Microsoft database tool update, now I get a "cannot open data source" error

It seems like the mail merge tool only wants to open .dbx or odbx file types.

How can I get the data from this excel sheet into publisher?
0
Comment
Question by:downsouf912
  • 2
5 Comments
 
LVL 23

Expert Comment

by:DanCh99
ID: 36539448
I've done merges from Excel 2003 into Word successfully in the past, but it's quite fiddly.  I'd suggest that you do a Save As to XLS in the first place.  I also recall that it was best to actually have the Excel sheet CLOSED when the merge runs.  

I've got some further notes at work which I can get tomorrow on the details of the procedure....

Is it essential that you use Publisher as well?
0
 

Author Comment

by:downsouf912
ID: 36542605
I'm not sure I can get out of publisher, the document is a newsletter that was designed in publisher and when I try to save as another file format, it changes the formatting of the document.

I had tried saving as a .xls but got the same error when trying to create the mail-merge.
0
 
LVL 23

Accepted Solution

by:
DanCh99 earned 250 total points
ID: 36915911
Finally got back to this - here's my crib sheet on the process for Word and Excel 2003.  Hope it's not too abbreviated....

get the addresses all sorted, in Excel - only one line per cell.
Save the changes, and CLOSE Excel.
Word, new blank doc - Tools.. Letters And Mailings.. Mail Merge..
choose Labels from the menu on the right, and click Next - Starting Document.
leave it on Change Document Layout, but click Label Options below
choose the label, for instance -set Label Products to be Avery A4 and A5 Sizes, then set the product number to be L7163, and OK - then, Next - Select Recipients.  
leave it on Use An Existing List, and click on Browse.. and find the main Excel document.  (ignore the scary My Data Sources, and NEW SQL Server Connection options - just browse for the Excel file above).
Once opened, it may offer a Select Table window - just leave this on the defaults and OK.  Leave the list of recipients alone, and click OK.  Click on Next: Arrange Your Labels.  
click on Address Block to ensure that the layout is good.  
Address Block.. Match Fields button.. <<<this bit is important!
Change any Not Matched to have the right entry.

FINALLY, click on Update All Labels - *important* - then Next - Preview Your Labels
and choose the Edit Individual Labels option to get the output.
Note - you'll get 2 documents out of this - a one page master showing the layout, and also one with the results - multiple pages.  
0
 
LVL 50

Expert Comment

by:teylyn
ID: 37412242
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel 6 18
Excel 3 22
TT Copy Formula 3 16
Determine 90 days from most recent date 3 18
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now