Recent content by gerry@docshop.ie

  1. G

    insert paragraph within table and vba

    Will the paragraphs contain text or are you trying to set the height of the cell? or something else?
  2. G

    Error creating formula based on a mailmerge field

    Hi, this is possible 1 place the Merge field with the number into your document, and then from the [insert tab] choose Bookmark to bookmark the MergeField. I called it NUMBER1 2. if you do not want to display this merge field, then on the Font options on the Home tab, select the merge field...
  3. G

    Printing from VBA with Word

    Control of the pages on the printer is through the page setup Selection.PageSetup.FirstPageTray = wdPrinterPaperCassette Selection.PageSetup.OtherPagesTray = wdPrinterPaperCassette I used the record macro to get the code to setup a page and the specific printer settings for the default...
  4. G

    Has the Smart Documents been discontinued in Ms Word?

    Try Quick Parts under the Insert Ribbon
  5. G

    Programatically joining templates?

    Use the template file as the starting point. create separate documents for each optional section. use the INSERT -> OBJECT -> Text from File to insert other word documents. Text inserted at the cursor location. Ensure that the styles for text are identical in all documents...
  6. G

    find and replace out of a list

    Hi This is possible through using some simple VBA, are you familiar with VBA?
  7. G

    Managing Word 2010 headers with revision status per page

    Hi, I can completely relate to what you are trying to achieve having worked as an aircraft tech for many years. Headers and Footers can initially be confusing for Word but once you get your head around the concept you will be well able to achieve your goal. The main point to...
  8. G

    Front page fields

    A mail merge sounds like exactly what you need. Could be setup with Excel Spreadsheet. How many pages would be produced by your selections. Can you attach a sample document, change the colour of the elements that will change.
  9. G

    Create duplicate records with incrementing dates

    You are very welcome,. Gerry
  10. G

    Create duplicate records with incrementing dates

    Hi Guinness I have modified your form and added a new button which runs a VBA Routine. I changed the names of the Combo Box fields to [cmb_Field Name] to make them more identifable. I would also suggest that in the dates table you change the field name to 'Working_Date' as 'Date' is a VBA...
  11. G

    Create duplicate records with incrementing dates

    No rush I will be alerted when you get to post and I will have a look then as soon as I can.
  12. G

    Create duplicate records with incrementing dates

    That sounds ok to get your cross tab. Can you zip up a copy of your tables with some sample data, It should be a simple Append Query or a short VBA Routine to achieve what you need. I do something similar with Nursing Homes where I get a range of rooms, I enter 1 to start and 25 as the end and...
  13. G

    Create duplicate records with incrementing dates

    Why do you need to have separate daily records? Could you have a record for each date range?
  14. G

    Using VBA to remove header & footer before printing

    amend code ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPagefooter
  15. G

    Mail Merge (Kind of) HTML Dynamic email and attachment

    Hi, To save to a specific folder prefix the filename with the destination folder "d:\mydocs\filename.doc" appword.ActiveDocument.SaveAs2 FileName:="path and filename.docx", FileFormat:=wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword:=""...
See more
Top Bottom