Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-17-2012, 08:42 PM
kckay kckay is offline Templates, pictures, Mail Merge and Excel Windows 7 32bit Templates, pictures, Mail Merge and Excel Office 2007
Novice
Templates, pictures, Mail Merge and Excel
 
Join Date: May 2012
Posts: 6
kckay is on a distinguished road
Default Templates, pictures, Mail Merge and Excel

I have an application in Excel that is used to perform inspections of water treatment facilities. After the inspection, the Excel worksheets are filled with information. A button on the ribbon is then used to create a summary of this information. Another button on the ribbon is used to generate a letter based on the summary information. Mail Merge is used to extract the Excel data and populate the Word template.



The template has a title block (as a picture). This title block has the Denver address only. I would like to copy OVER this title block with another that contains the address of the Grand Junction office or the Pueblo office.

What VBA code allows me to write over an existing title block picture on the template? Or maybe delete the existing title block picture - I could than add the required title block.

I already wrote code that adds the additional address block (GJ or Pueblo) under the existing title block picture, but would rather clean it up and have it all in the same area.

I would like to attach screen shots of what I currently have and what I would like, but do not know how.

Last edited by kckay; 05-17-2012 at 08:45 PM. Reason: Additional info
Reply With Quote
  #2  
Old 05-17-2012, 08:51 PM
kckay kckay is offline Templates, pictures, Mail Merge and Excel Windows 7 32bit Templates, pictures, Mail Merge and Excel Office 2007
Novice
Templates, pictures, Mail Merge and Excel
 
Join Date: May 2012
Posts: 6
kckay is on a distinguished road
Default

Never mind. I hacked it and used a selection.delete to remove the original title block, then added the new title block with the additional address.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import field from Excel to Powerpoint xgravity23 Office 8 11-22-2012 02:08 PM
Templates, pictures, Mail Merge and Excel Mail Merge from Excel Kieroncsmith Mail Merge 2 02-16-2012 10:35 PM
Templates, pictures, Mail Merge and Excel Word mail merge from a protected Excel worksheet Platform Mail Merge 10 09-28-2011 05:12 AM
Help with switches: Word mail merge with Excel ks_ Mail Merge 0 12-09-2009 05:09 PM
Templates, pictures, Mail Merge and Excel Templates and pictures Jan Drawing and Graphics 3 08-04-2009 11:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 AM.


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