Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge excel into word and email
Mail Merge. See these sites fro info:
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm http://www.j-walk.com/ss/excel/tips/tip92.htm Also, check this out: See these links for a wealth of information: http://word.mvps.org/FAQs/InterDev/XLToWordWithDAO.htm http://word.mvps.org/faqs/interdev/c...wordfromxl.htm http://word.mvps.org/FAQs/InterDev/C...XLFromWord.htm Finally, and this is my personal favorite: Add DocVariables to your Word document, wherever you want the Excel data to go. For instance in Word click Insert Field DocVariable New Name (I used First_Name in my example) OK. You will see a space reserved for the variable. Tap Alt+F9 to display or hide the DocVariable. There are many, many other methods, using bookmarks, etc. I think the DocVariable method is the best for countless reasons (too many to go into here; try it you will see the benefits of using this method). Sub ControlWordFromXL() Dim objWord As New Word.Application Dim doc As Word.Document Dim bkmk As Word.Bookmark sWdFileName = Application.GetOpenFilename(, , , , False) Set doc = objWord.Documents.Open(sWdFileName) On Error Resume Next Sheets("Sheet1").Activate objWord.ActiveDocument.Variables("First_Name").Val ue = Range("First_Name").Value objWord.ActiveDocument.Variables("Last_Name").Valu e = Range("Last_Name").Value €˜etc€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦€¦. objWord.ActiveDocument.Fields.Update On Error Resume Next objWord.Visible = True End Sub Regards, Ryan-- Regards, Ryan--- -- RyGuy "nick thompson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do a mail merge to email via excel | Excel Discussion (Misc queries) | |||
Trying to merge from excel to word. New names won't merge | Excel Worksheet Functions | |||
email merge in Excel | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
In XP how do I merge Word doc with Excel list and email? | New Users to Excel |