Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-22-2011, 05:17 PM
stephen_pen stephen_pen is offline Automation Word-Excel Windows 7 32bit Automation Word-Excel Office 2010 32bit
Novice
Automation Word-Excel
 
Join Date: Sep 2011
Posts: 3
stephen_pen is on a distinguished road
Default Automation Word-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
Reply

Tags
automation, excel 2010, word2010

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Word-Excel Word, Excel automation Paul-NYS Office 3 06-29-2011 01:11 AM
Automation Word-Excel Urgent help regarding automation. aligahk06 Excel 1 01-14-2010 01:55 PM
Table of contents automation through VB 6.0 Developer Word 0 06-09-2009 06:30 AM
What is Application Automation and How can I use it in VBA KramerJ Excel 0 03-30-2009 12:59 PM
COM Automation Errors ivanm Word 0 03-23-2009 07:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:45 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