Question about Microsoft Office Standard for PC

1 Answer

Merge two records in ms works 2000

I want to be able to merge two or more records in Microsoft works 2000
I started with an ascii II file of addresses. I imported that list into an Excell spreadsheet. When I did this it put only part of the address on each row so when I imported into Excell each address became 4 or 5 different rows. Therefore the data base became 4 or 5 records.I would like to merge them into only one record.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

The easiest way I could think to do this was using text formulae concatenate - The issue I thought you might have was the lack of spaces between each entry - hence the " "

=CONCATENATE(B2," ",B3," ",B4,B5,B6)

Posted on May 21, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

The list of contacts is empty in OE 6


I know that when a large number of entries in the address book in OE (more than 999) contacts disappear. Check the number of contacts and liberate the place.
If with number of contacts everything is normal then it is necessary to restore them through Address Book Restore Toolbox. Here it is possible to find it http://www.addressbook.restoretools.com/
If nothing helps, then read the forum and look for there advice
http://www.filerepairforum.com/forum/other/other-aa/address-book/1430-how-to-restore-ab-of-oe

Feb 22, 2015 | Microsoft Outlook Express

3 Answers

I have Outlook Express for my e/mail, my sever is Broadband and they changed my e/mail over to Magic Mail, this leaves my address book back in Outlook Express. I know I have to make a file and export the...


In Outlook, you can use the Import and Export Wizard as the interface for Address Book conversion. To convert a WAB file, follow these steps: 1. Start Outlook if it is not currently running. 2. On the File menu, click Import and Export. 3. Select Import Internet Mail and Addresses, and then click Next. 4. Select Outlook Express 4.x, 5 from the list, and then click Next. 5. Select the product for which you wish to convert items from the list, and then click Next. 6. Select any combination of the Mail or Addresses from the items listed.

NOTE: With the exception of rules conversion from Outlook Express, the steps to convert addresses is the same. 7. Click Next. 8. Select a destination for the imported address data. The destination depends on the type of Outlook installation you selected initially. a. The Internet Mail Only installation of Outlook 98 allows only the Contacts folder as the destination. b. The Corporate or Workgroup option allows the options of Personal Address Book or Outlook Contacts. 9. Select the appropriate duplicate items option. Click Finish to complete the import.
Hope that helps..........

Jul 10, 2008 | Computers & Internet

1 Answer

Properties in importing excel table to an access table


This article explains how to import a Microsoft Excel file into Microsoft Access version 2.0 or 7.0. Microsoft Access can import files from Microsoft Excel version 2.0 through version 7.0. However, Microsoft Access cannot import Microsoft Excel 4.0 workbooks (.xlw). This article assumes that the Microsoft Excel file is using standard database formatting. That is:

To import a Microsoft Excel file in Microsoft Access 2.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 2.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Import. From the Import dialog box, choose the appropriate version of Microsoft Excel that you are importing and click the OK button. Microsoft Excel 7.0 files are not on this list. If you are importing a version 7.0 file, choose the Microsoft Excel 5.0 option.
At this point options such as whether to append to an existing table or create a new table may be selected.
To import a Microsoft Excel file in Microsoft Access 7.0 loadTOCNode(2, 'moreinformation');
  1. Save the file in Microsoft Excel using standard database formatting listed above. Close the file.
  2. Start Microsoft Access 7.0 and open the database you want to import the Microsoft Excel information into.
  3. On the File menu, click Get External Data and then click Import.
  4. From the import dialog box, choose Microsoft Excel (*.xls) for the Files Of Type option.

    This will display only the Microsoft Excel files.
  5. Find the desired file and click the Import button.
The Import Spreadsheet Wizard appears and allows you to choose options specific to the file.

or you just use the link for any problem where you can get details of the importing
http://www.techrepublic.com/article/techniques-for-successfully-importing-excel-data-into-access/5276622

May 05, 2011 | Computers & Internet

1 Answer

Want to import email addresses into MS Outlook


Hey! follow the steps to get your job done


You can import address book contacts from other Microsoft Windows® Address Book files (.wab), as well as from Netscape Communicator, Microsoft Exchange Personal Address Book, or any text (.csv) file.
For Windows Address Book 1.
On the File menu, point to Import, and then click Address Book.
2.
Select the address book or file type you want to import, and then click Open.

For All Other Address Book Formats 1.
On the File menu, point to Import, and then click Other Address Book.
2.
Click the address book or file type you want to import, and then click Open.

If your address book is not listed, you can export it to either a text (.csv) file or a Lightweight Directory Access Protocol (LDAP) or Lightweight Directory Interchange Format (LDIF) file, and then import it using that file type.



Good luck :-)

May 27, 2010 | Microsoft Windows XP Home Edition

1 Answer

HP Media Center desktop PC running XP, 250 Gb hard drive,


The Address Book provides a convenient place to store contact information for easy retrieval from programs such as Microsoft
loadTOCNode(2, 'summary'); To open the Address Book, click Start, point to All Programs, point to Accessories, and then click Address Book.

To open the Address Book in Outlook Express, click Address Book on the Tools menu.
Import Address Book Contacts from Other Windows Address Book Files loadTOCNode(2, 'summary'); You can import address book contacts from other Windows Address Book files (.wab files), as well as from Netscape Communicator, Microsoft Exchange Personal Address Book, or any text file (.csv file).

To import Windows Address Book files:
  1. In Address Book, point to Import on the File menu, and then click Address Book (WAB).
  2. Locate and then click the address book that you want to import, and then click Open.

Dec 29, 2009 | Computers & Internet

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

I have a CD-ROM that contains 1 file. The file is in ASCII (text) Delimited Format with 3.2 million records with 526 megabytesin its current format. What relational database package can be used to setup...


Assuming you mean that this file is tab delimited or something similar any relational database software should work fine. Some suggestions are Microsoft Access, MySQL, MS SQL and SQLite. There are so many others here is a link a list of others http://en.wikipedia.org/wiki/List_of_relational_database_management_systems

Mar 20, 2008 | Computers & Internet

4 Answers

How to create mailing labels in Microsoft Works


With a Microsoft Works Word document open, select: Tools>Labels>(the list of available label types will pop up, select the label sheet you're using) then select: Tools>Mail Merge>Open Data Source...

Don't know how it could be simpler.

Dec 18, 2007 | Microsoft Works 8.0 for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3000 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...