Search results

  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:=""...
  16. G

    Mail Merge Check Box's

    I know this has been here a long time. The simplest solution to this problem is to create a calculated field in your merge query. instead of using the Yes or No use the characters for the symbol you want in the Wingdings or other font face. make sure to create and apply a Character Style to the...
  17. G

    Incorrect Figures in mail merge

    You need to create a calculated field in your query that combines the currency symbol with the number ( expr123: "£" & [Table]![Field] ) . If the field is already as calculated field then use Expr123: "£" & [Table1]![Field1] &...
  18. G

    Word VBA - Heading Styles

    Hi Trevor G If you have used have already applied styles Heading 1, Heading 2 and Heading 3 across the document then this change is simple. In Word 2010 or 2013 (will be something similar in previous versions), go the the Styles ribbon on the Home tab. Right Click on the Style to be modified...
  19. G

    Populating word form fields from access

    Glad I could help!
  20. G

    Populating word form fields from access

    The document opened can refer to being a new document based on any template. Set MyDoc = wordApp.Documents.Add("Templatepath\Filename.dotx") My document is also made up of optional additional pages and these are easily inserted at the cursor location wordApp.Selection.InsertFile...
Top Bottom