Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Converting MSWorks mailing list to a Data Source for use in Word
I want to use my list of addresses in MS Works as a mail merge in Word
(Office 2003) . The following message appears "Office cannot use Works files containing formulas for mail merge. Remove formula to use as a data source." I have not created any formulas that I'm aware of. What formula does this refer to and how do I remove it? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Converting MSWorks mailing list to a Data Source for use in Word
Broadly speaking, Word has two ways to get data from a Works database:
a. the Word way, where you use the Mailmerge Wizard or Toolbar to select your data source b. the Works way, which uses a special addin that comes with Works to get the data from your .wdb. This installs a Tools menu item called "Address Book Mail Merge". if you see that menu, try creating your merge using it, and select "Merge information from another type of file" when prompted. As far as I know, if you use (a) you may see the "formula" error you describe, although I would not expect it if you have no formulas in your ..wdb. If you use (b), the add-in should process the formulas correctly if there are any. If you do not see the Address Book Mail merge option, either the works addin is not installed or not working. If it is not working, it could be because you are using Word 2003 rather than Word 2002 which I think is still the version that comes with Works Suite (but I haven't kept up-to-date on that front). To check if you do have any formulas in your .wdb, you can a. open the database b. use View|List to show the data in "spreadsheet" format c.select the first field in the first row, and look at the formula bar above - if it just contains a value, you will see something like "thevalue. If it contains a formula, you will see something like =theformula e.g. =fielda+fieldb etc. Personally, I wouldn't try too hard to get .mdb format to work. In the long run it may be easier to get used to exporting the data from Works Database (I would use File|Save As, and choose "Text & Commas" or "Text & Tabs" in the "Save as type" dialog box). Peter Jamieson "Lossie Loon" Lossie wrote in message ... I want to use my list of addresses in MS Works as a mail merge in Word (Office 2003) . The following message appears "Office cannot use Works files containing formulas for mail merge. Remove formula to use as a data source." I have not created any formulas that I'm aware of. What formula does this refer to and how do I remove it? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Converting MSWorks mailing list to a Data Source for use in Wo
Thank you Peter - sounds as if that will do the trick. I've found a formula
(Tdate has "=NOW). now I can get my Christmas Card labels printed! "Peter Jamieson" wrote: Broadly speaking, Word has two ways to get data from a Works database: a. the Word way, where you use the Mailmerge Wizard or Toolbar to select your data source b. the Works way, which uses a special addin that comes with Works to get the data from your .wdb. This installs a Tools menu item called "Address Book Mail Merge". if you see that menu, try creating your merge using it, and select "Merge information from another type of file" when prompted. As far as I know, if you use (a) you may see the "formula" error you describe, although I would not expect it if you have no formulas in your ..wdb. If you use (b), the add-in should process the formulas correctly if there are any. If you do not see the Address Book Mail merge option, either the works addin is not installed or not working. If it is not working, it could be because you are using Word 2003 rather than Word 2002 which I think is still the version that comes with Works Suite (but I haven't kept up-to-date on that front). To check if you do have any formulas in your .wdb, you can a. open the database b. use View|List to show the data in "spreadsheet" format c.select the first field in the first row, and look at the formula bar above - if it just contains a value, you will see something like "thevalue. If it contains a formula, you will see something like =theformula e.g. =fielda+fieldb etc. Personally, I wouldn't try too hard to get .mdb format to work. In the long run it may be easier to get used to exporting the data from Works Database (I would use File|Save As, and choose "Text & Commas" or "Text & Tabs" in the "Save as type" dialog box). Peter Jamieson "Lossie Loon" Lossie wrote in message ... I want to use my list of addresses in MS Works as a mail merge in Word (Office 2003) . The following message appears "Office cannot use Works files containing formulas for mail merge. Remove formula to use as a data source." I have not created any formulas that I'm aware of. What formula does this refer to and how do I remove it? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
Word & WordPerfect | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
How Come? | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge |