![]() |
Excel to Word
I need to have two columns in Word document in a certain format and each
first two cells on each page. SR # Owner Description 1-35340445 IYERSRID **** Check issued to **** Employee #: XXXXX Employee Name: abc, xyz Reason for Check: Other Employee Status: Active Employee Location: 000055 A check should be issued for the following hours: 1st week ending (must be a Saturday): 09/22/2007 Regular Hours: 35.05 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: 2nd week ending (must be a Saturday): 09/15/2007 Regular Hours: 34.98 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: Send Check to Location#: 55 Comments: Employee's hours were submitted, but employee did not receive a check. Thanks. Corporate locations only Manager pick up check: there are around 150 such rows and I need it on 150 pages in Word with the Description column in a certain format. |
Excel to Word
Take a look in Word's help with regards to mailmerge and you are probably
better off posting this in a Word newsgroup -- Regards, Peo Sjoblom "aliya.pawaskar" wrote in message ... I need to have two columns in Word document in a certain format and each first two cells on each page. SR # Owner Description 1-35340445 IYERSRID **** Check issued to **** Employee #: XXXXX Employee Name: abc, xyz Reason for Check: Other Employee Status: Active Employee Location: 000055 A check should be issued for the following hours: 1st week ending (must be a Saturday): 09/22/2007 Regular Hours: 35.05 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: 2nd week ending (must be a Saturday): 09/15/2007 Regular Hours: 34.98 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: Send Check to Location#: 55 Comments: Employee's hours were submitted, but employee did not receive a check. Thanks. Corporate locations only Manager pick up check: there are around 150 such rows and I need it on 150 pages in Word with the Description column in a certain format. |
Excel to Word
This would be a mail merge process in Word, and if you look up "Format merged
data " in Word Help you'll get information on how to format numeric data in a mail merge process. However, as Peo Sjoblom has already noted, the Word forum would be your best bet on getting the assistance that you need. -- Kevin Backmann "aliya.pawaskar" wrote: I need to have two columns in Word document in a certain format and each first two cells on each page. SR # Owner Description 1-35340445 IYERSRID **** Check issued to **** Employee #: XXXXX Employee Name: abc, xyz Reason for Check: Other Employee Status: Active Employee Location: 000055 A check should be issued for the following hours: 1st week ending (must be a Saturday): 09/22/2007 Regular Hours: 35.05 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: 2nd week ending (must be a Saturday): 09/15/2007 Regular Hours: 34.98 Overtime Hours: Other Hours: Indicate Type of Hours: Other Hours: Indicate Type of Hours: Send Check to Location#: 55 Comments: Employee's hours were submitted, but employee did not receive a check. Thanks. Corporate locations only Manager pick up check: there are around 150 such rows and I need it on 150 pages in Word with the Description column in a certain format. |
All times are GMT +1. The time now is 12:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com