Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

create printable form that has data from excell document insertet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pam - 29 Jun 2006 19:01 GMT
I have information on pay for my employees on an excell spreadsheet. I need
to create a form that looks like a check stub that i can print with this
information in it each week to give to the employee. (the excell information
needs to be merged into the pay form)?
JLatham - 30 Jun 2006 02:46 GMT
Creating forms in Excel can be rather tedious, as you've probably realized.  
Also, to create something that would spit out numerous duplicate looking
pages would require that the 'form' be replicated in Excel once for each
employee.

A better way would be to create the form in Microsoft Word as a Mail Merge
document.  You can layout the form much better and it'll be nicer looking
there than from Excel unless you put a lot of effort into the Excel side.

What you will need to do is set up one sheet in your Excel workbook to act
as a Data Source for the Word Mail merge.  Each employee's information should
be on a single row across the sheet, with headings for each column in row 1
on the sheet like this:
           A         B                    C               D               E
1       NAME    SSAN             RATE          HOURS      Gross Wages...
2      J SMITH 123-45-6789    $15.75           24.4         $384.30
3

and continue across the sheet with all information that needs to go on the
stub.  You can even use references to data on other sheets to get the data
onto this one and use formulas to create some entries (like I could have used
=C2 * D2 in E2 to get the gross wages).

Each of the entries in row 1 will become Mail Merge fields when setting
things up in Word.  The Mail Merge 'wizard' in Word will very much lead you
by the hand when you start building this.  When you get to the part about
selecting the Data Source, choose 'browse' and identify the Excel workbook.  
It will then require you to identify the worksheet in that workbook that has
this list on it.  After that, it's a piece of cake.

> I have information on pay for my employees on an excell spreadsheet. I need
> to create a form that looks like a check stub that i can print with this
> information in it each week to give to the employee. (the excell information
> needs to be merged into the pay form)?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.