Excel/Pushing data from an Excel to a Word document
We take reservations by phone using an Excel template into which we enter information such as arrival and departure dates of guests, No. of people, tariffs, totals, etc. This is then saved as an Excel file.
Info from particular cells in this Excel document is subsequently entered into a table which is part of a word template. This is then stored as a document and emailed to the client.
Unfortunately people make mistakes when they transfer this info manually from Excel to Word. How can I automate this process? In other words, how can I "push" specific info to the Word doc, by means of links?
Note: It would have been simple if this document could rather have been an Excel doc as well. However, it isn't practical since it contains a letterhead, other graphics and a substantial amount of other information.
I'm not familiar with VBA at all but I can give it a go if I can get step-by-step guidance.
Thanks and kind regards.
I would think VBA could be used for this - but if you don't know VBA, then trying to link Excel to Word plus adding in the functionality you describe might be a bridge too far. You can't really give step by step instructions on how to write a VBA code solution - particularly if the person writing the instructions has no detailed knowledge of the requirement.
What does occur to me is the mail merge feature of word. It allows you to create form letters and populate the data in the form letter from a database - of which excel can be used as the source for that database. That kind of sounds like what you are doing.
Another way would be to create links in word back to the excel source or to do some type of copy and paste as a link.
That is about the best suggestions I can give you given the very general description you provided.
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here