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 / Word / Mailmerge and Fax / October 2003

Tip: Looking for answers? Try searching our database.

merging HR list with timesheet(s)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
gary G. - 13 Oct 2003 19:58 GMT
We are using Word 2002 and Exel 2002.  We would like to be
able to take the employee information such as name
address, phone, title, etc., that is stored a an excell
spread sheet and put it into a timesheet that is a word
document.  We would like to print up individualized
timesheets for each person.

How can we do this?  Any help would be appreciated.
Doug Robbins - Word MVP - 14 Oct 2003 10:56 GMT
Hi Gary,

Starting with your timesheet document, turn on the mailmerge toolbar (View
Toolbars) and using the first button on the left, select "Letters" as the
main document type to create.  Then using the second button from the left,
navigate to and open the Excel spreadsheet that you want to use as the data
source.    Then using the sixth button from the left, insert the mergefields
into the appropriate places in the main document.  Then execute the merge to
the appropriate destinate by using the buttons at the right hand end of the
toolbar.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> We are using Word 2002 and Exel 2002.  We would like to be
> able to take the employee information such as name
[quoted text clipped - 4 lines]
>
> How can we do this?  Any help would be appreciated.
 
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.