Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) |