![]() This second way, while a little bit more involved, has some clear advantages. Run a mail merge from Gmail, but import your Excel and Word docs into Google.Add your Gmail account to Outlook, then a run a mail merge from Excel and Word.Hope this helps you, but I fear that you are not yet familiar with the bulk-processing process that 'mail merge' generally applies to where many (ie, could be thousands) of lines are one-by-one processed through a single setup sheet, printed, then the sheet re-used for the next line-item (or row).Users operating from a Gmail account who prefer Excel and Word over Google Docs can still run a mail merge with their Gmail account. The #N/A appears to be produced by an incorrectly sorted table for the Lookup, but I would wonder not why 'Buckingham' was #N/A but why all items alphabetically prior to 'Venue' were not also #N/AĪdd ,False to your VLookup to avoid the #N/A, or setup a Lookup table that excludes the 'Venue' header (or change the word 'Venue' to 'At' so that it is alphabetically before the first required item). Interesting concept, but a high overhead small volume system (because of the cell merging/formatting and that you keep a copy of the tables and a separate Name set on each Sheet). There is an error with "Buckingham Palace" which brings up "N/A", as I said I'm no programmer, if you don't know how to fix it, then I'm sure someone will help. There on the same page as the validation list wouldn't allow me to have it on a different sheet - if anybody out there knows how to do that I'd appreciate you sharing your knowledge with me. The payroll information comes from the payroll number drop down list and the venue from the Venue list, which are both named ranges in the namebox. I have used vlookup and validation lists. Of course all payroll details are made up!! As you can see I'm no programmer that's why it's simple with no macros! but it might inspire you. ![]() I developed something similar for jobs and invoicing (that's why it looks a little like an invoice, but it at least shows other calculations). I've attached a file to see if this is the sort of thing you are trying to achieve. If you want a respectable looking print then consider Excel-to-Word, whereby all the calculations are performed in Excel, and the 'items' to be printed are passed to Word as described by in If your print is a simple one that can be setup on a template worksheet and not become disjointed by the variety of data you have, then a simple loop which transfers row-by-row cells to the template and Prints the sheet should suffice, such a loop could be started by Tools, Macro, Record New Macro and perform the action of printing, then Stop Recording and Edit the Macro to add a loop. Your reply seems to indicate two things, that you have not yet attempted 'elegant' printing in Excel, and that you have not understood the concept of Excel-to-Word mail merge. Additionally, when first beginning this project it never occurred to me that I might want to be able to do this.Ĭan you (or anyone) direct me to any sources that might show me how to create such a macro? The reason I am keeping it in excel is because of the complexity of some of the formulas involved (I am sure they are possible to compute in word, however, i am not as experienced in doing so).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |