#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Word copying info from Excel to Word without gridlines / bor Renee Thomas Excel Discussion (Misc queries) 2 September 13th 07 09:24 AM
Copy from Word to Excel, and retain indent, plus word wrap Eric Excel Discussion (Misc queries) 1 March 9th 07 03:15 AM
Link table from excel to word using word VBA [email protected] Excel Discussion (Misc queries) 7 January 9th 07 05:57 PM
Excel Hyperlink doesn't open Word doc the same way as Word does duugg Excel Discussion (Misc queries) 2 October 12th 06 03:14 PM
Print labels by using Excel data in a Word mail into word Zoey Excel Discussion (Misc queries) 1 November 1st 05 09:08 PM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"