ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel to Word (https://www.excelbanter.com/excel-discussion-misc-queries/160729-excel-word.html)

aliya.pawaskar[_2_]

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.


Peo Sjoblom

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.




Kevin B

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