LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default merge excel into word and email

ni have a spreadsheet with colums of info.The firstcolumn has always someones
name and a row may repeat someones name.What i want to do is send by email
this information to the correct person.I was hoping to do a merge in word and
then send the document.However, it is proving impossible to use merge and get
the info for each person on one page.
Example

Excel sheet
Joe bloggs, column 2, column 3 ,column4
Sarah Green,colum 2,colum 3,colum,4
Joe Bloggs, colum2 ,column 3 ,column 4

i want to be able to email to each person

Word document 1 sent to joe bloggs

Joe Bloggs,column,2,column3,column4
Joe Bloggs,colum2, column3,column4

total column2,total column3,total column 4


second document

Sarah Green,column2,column3,colum4
total column2,total colum3,total colum3
--
nick
 
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
How do I do a mail merge to email via excel Kris - Recruiter for Hospital Excel Discussion (Misc queries) 1 March 17th 08 12:30 PM
Trying to merge from excel to word. New names won't merge ruth tozer Excel Worksheet Functions 0 June 27th 07 05:58 AM
email merge in Excel bnc Excel Discussion (Misc queries) 0 June 6th 07 11:54 PM
mail merge excludes my headers and critical data in Word merge Nix Excel Discussion (Misc queries) 0 April 21st 06 08:35 PM
In XP how do I merge Word doc with Excel list and email? macinga New Users to Excel 1 January 12th 06 03:39 PM


All times are GMT +1. The time now is 10:25 PM.

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

About Us

"It's about Microsoft Excel"