Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default copying info from one workbook to another one

I'm working on a spreadsheet with all employee names and their annual
deductions. I need to send them a letter, addressed to each employee with
the specific deductions that each has. How can I copy the info from my
spreadsheet to my letter either using microsoft office or microsoft excell
(not sure which one would be easier). I'm not too familiar with all the
funtions of excell, I only know the very basic on the formulas. Please help,
I've spent so much time trying to look it up but no luck. thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default copying info from one workbook to another one

I would suggest utilizing the excellent mail merging features of MS Word
which is part of MS Office.

Open Word and go to ToolsMailMerge.

Use Excel as the source for the mailmerge.

See these sites for help.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP

On Tue, 7 Apr 2009 14:49:02 -0700, Mago
wrote:

I'm working on a spreadsheet with all employee names and their annual
deductions. I need to send them a letter, addressed to each employee with
the specific deductions that each has. How can I copy the info from my
spreadsheet to my letter either using microsoft office or microsoft excell
(not sure which one would be easier). I'm not too familiar with all the
funtions of excell, I only know the very basic on the formulas. Please help,
I've spent so much time trying to look it up but no luck. thanks


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
Copying info from two cells so that it is searchable later Tracy Excel Worksheet Functions 1 November 17th 08 02:11 AM
copying excel info into word EricS Excel Discussion (Misc queries) 2 June 6th 07 04:13 PM
Trouble copying info into a spreadsheet Meenie Excel Worksheet Functions 9 March 20th 07 05:13 PM
Need another Formula Help for Copying Info Between 2 Pages EmanJR Excel Discussion (Misc queries) 4 September 27th 06 06:10 PM
Copying Info Into Numerous Cells calimari Excel Discussion (Misc queries) 3 July 7th 05 06:36 PM


All times are GMT +1. The time now is 01:14 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"