Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I copy a list from Works to Excel?
I have a telephone list in A Works data base. I copied and pasted it to
Excel. I would like to mail merge, but when I go to Word and try to retrieve the list, it is not there. However,when I do a print preview in Excel, it shows up. What did I do wrong? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I copy a list from Works to Excel?
Did you save the excel file?
Did you put the list in the leftmost worksheet? You may want to ask in an MSWord forum. But... You may want to read some tips for mailmerge. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. And if you notice problems with the formatting of data (like zipcodes)... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"ddmmyy") or =text(a2,"mm:ss.0") or =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) Millie wrote: I have a telephone list in A Works data base. I copied and pasted it to Excel. I would like to mail merge, but when I go to Word and try to retrieve the list, it is not there. However,when I do a print preview in Excel, it shows up. What did I do wrong? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a donor mail list from excel into Microsoft works database | New Users to Excel | |||
HELP! Copy/Paste Macro Works on PC But Not Mac! | Excel Discussion (Misc queries) | |||
Automatic insert the last number in a list to another Excel works | Excel Discussion (Misc queries) | |||
Works if I copy F Col to A Col | Excel Worksheet Functions | |||
How do I convert works file to excel without works software? | Excel Discussion (Misc queries) |