Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2011, 09:13 AM
stephen_pen stephen_pen is offline Integration of Word and Excel Windows 7 32bit Integration of Word and Excel Office 2010 32bit
Novice
Integration of Word and Excel
 
Join Date: Sep 2011
Posts: 3
stephen_pen is on a distinguished road
Default Integration of Word and Excel

Hello, everyone,


I have a new job and will be responsible for the company's weekly Newsletter. I plan to create and Excel table with each row holding the complete text for the Newsletter by topics (in columns). Each week is a new row.

When I open the Newsletter template in Word 2010, it should open this Excel table, use the last row only and fill in the provided fields with text from Excel.

Then Mail Merge will open the address table and email the newsletter to each customer.

Question: How can I make Word 2010 to read the text from the last row of Excel table? And will this action take place BEFORE Mail Merge?
Reply With Quote
  #2  
Old 09-26-2011, 04:53 AM
OTPM OTPM is offline Integration of Word and Excel Windows 7 32bit Integration of Word and Excel Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Stephen
Yes this is possible.
Firstly you need to write a Word Macro that opens an instance of Excel and the document that contains the data you want to read.
Once you have done that then to find the last row of data in an Excel sheet use this line of code:
LastRow = ActiveSheet.UsedRange.Rows.Count
You can then add the code to do your MailMerge.
Hope this helps.
Good luck.
Tony(OTPM)
Reply With Quote
Reply

Tags
automation, excel 2010, word 2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Integration of Word and Excel Excel Link in word chandan56 Office 3 07-02-2015 07:07 PM
Integration of Word and Excel Excel Tables to MS Word ripcurlksm Word Tables 2 09-09-2011 04:59 AM
Integration of Word and Excel Word to Excel rynman Office 5 04-19-2009 06:50 AM
Integration of Word and Excel Excel to Word retrospect1984 Excel 1 02-18-2009 06:41 AM
Linking from Excel to Word streng Word 4 10-28-2008 08:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft