Question about Xerox Phaser 8550DT Thermal Printer

1 Answer

Excel Is there a way to merge 2 different excel 2007 documents into one document? some rows will be the same and need to be matched such as the name cells. MS has a compare and merge for the same shared document, but I cannot seem to find anything for merging different excel workbooks into one (exept third party software).

Posted by on

  • hbulmer Mar 12, 2009

    Thank you, and I do appreciate the post.

    That is for Excel 2003 - I am working with 2007.

    I am not looking to consolidate figures, but compare and match names between 2 spreadsheets create a new spread with the names and the additional information from both spread sheets.

    I pull preconfigured excel spreadsheets from an offsite SQL database. The information I require is in multiple spreadsheets for our members (which is why I want to compare by name or possibly member number) and merge the information into one excel workbook.

  • hbulmer Mar 12, 2009

    Thank you so much for your help and quick responses :-)

    I think the only way to do this is going to be a third pary application.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Expert
  • 62 Answers

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

HP LaserJet 3050 All-In-One Printer blank pages after attempting to print second envelope from same document - turning off and back on solves temporarily


If the same fault occurs with different printers it is almost certainly caused by the document.
"...second envelope from same document" suggests you are using a mail-merger. Is that right?
What happens if you start again from scratch? Mke a new document and try to print it a a single entity, without using mail merge?

Feb 05, 2016 | HP LaserJet 3050 All-In-One Printer

1 Answer

Scanner image is askew


Base on your explainination it seems like, this is because of your setting in MP Navigator, the image may not be scanned properly. In such a case, it is necessary to match the settings in MP Navigator to the document. please do the following. 1) Match the type of the document on the platen glass to the document type set in MP Navigator. For example, when scanning a color photo, select Color Photo in Document Type of MP Navigator. 2) Match the size of the document on the platen glass to the document size in MP Navigator. For example, when the document size is A4, select A4 in Document Size of MP Navigator. (Memo) Auto Detect is set in Document Size as the default.

Sep 09, 2007 | Canon Pixma MP500 All-In-One InkJet...

1 Answer

I cannot figure out how to scan multiple pages into one document using my hp envy 5530 and then send them in my AOL email as an attachment


I do this by:
1. Scanning each document and printing each one to a pdf file (using the free doPDF prgrame from http://www.dopdf.com/)
2. Merge the individual pdf files into one pdf file using PDFtk (from http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/)
3. send the merged file
Hope this helps.

Dec 18, 2013 | HP Photosmart C3180 All-In-One InkJet...

1 Answer

I"m trying to import a addresses using a csv Excel


The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!

Feb 18, 2011 | Xerox WorkCentre Pro 123/128 Printer

1 Answer

NEED TO KNOW HOW TO PRINT MORE THAN 1 ENVELOPE AT A TIME. DO LETTERS AND ENVELOPES ONCE A WEEK BUT THE PRINTER WOULD ONLY PROCESS 1 ENVELOPE AT A TIME AND I HAD TO DO THAT ONE MANUALLY.


Hi there !

For printing bulky letters or documents of the same format, I suggest you use the MS word mail merge document. You need to set up the mail merge document and the data of the file. For examples, the list of names, addresses telephone numbers and others should be input to the envelops.

Here's how to create mail merge document file.


1. Open a new blank MS word document or if you have a format already in a MS word format, just use it as default letter.

2. Go to menu bars (Home, Insert, Page Layout, References, Mailing, Review and View) and choose Mailing.

3. From Mailing, click on select recipients, choose use existing lists and find the excel document files that stores all the information like list of customers, company names, addresses, telephone numbers and others.

4. Open it and select table will appear and just click ok to merge it automatically to your default envelope.

5. Now you need to set up or format your envelope. from the Mailing menu, Insert Mail Merge Field will appear and click it to display the headings of your data source. Put the headings wherever you want.

6. After that, press preview result to display the datas. Save your work and it is finished

7

Jan 06, 2011 | Lexmark X 546dtn AllInOne Laser Printer

1 Answer

HP4000n (Not printing borders on Excel and Word)


this is because your document content is out of range for your printer settings
clik on file - page setup and adjust your document properties from there

Jul 24, 2009 | Printers & Copiers

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

Merging attachments of scanned files sent by email


You can use the IP Scanner software to scan the documents from your Bizhub to your pc. Once the documents are in your PC you can take apart which pages you want from the scanned documents and save them to another file and e-mail them through your computer that way.

Jul 21, 2008 | Konica Minolta bizhub C250 All-In-One...

Not finding what you are looking for?
Xerox Phaser 8550DT Thermal Printer Logo

Related Topics:

113 people viewed this question

Ask a Question

Usually answered in minutes!

Top Xerox Printers & Copiers Experts

Whit
Whit

Level 1 Expert

185 Answers

iteminconline

Level 2 Expert

110 Answers

Philip Hughes

Level 2 Expert

63 Answers

Are you a Xerox Printer and Copier Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...