Merge field truncated to first 18 characters from source?

Discussion in 'Word VBA' started by NicoleC, Feb 18, 2014.

  1. NicoleC

    NicoleC Guest

    Hi all,
    I have a Word template that merges data from an Excel file. I need to add a new merged field to this template that truncates the source data to the first 18 characters. In other words:

    Within the Excel file is a field called <<title>> which I've added to the Word template (as <<title>>), how do I truncate this word field to the first 18 characters of data in the excel "title" field?

    Unfortunately, if I could add a field to the Excel file, this would be easy but I'm using a proprietary system that calls does not allow the Excel table to be changed in anyway. I am limited to altering the Word template only.

    Does doing this in Word require a VB code? BTW - the last time I used VB was as a student and I think it was VB ver.2 (I'm showing my age!0 and I don't really remember much from that class!! So, any help you can offer is greatly appreciated!

    TIA!
     
    NicoleC, Feb 18, 2014
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. N-Force
    Replies:
    0
    Views:
    85
    N-Force
    Jul 30, 2003
  2. Bobby Hopper

    How to determine if data is truncated

    Bobby Hopper, Oct 15, 2003, in forum: Word VBA
    Replies:
    1
    Views:
    103
    Word Heretic
    Nov 9, 2003
  3. Kerri
    Replies:
    0
    Views:
    96
    Kerri
    Sep 2, 2004
  4. Shane Buchholz

    Clearing Merge Data Source and Merge FIle

    Shane Buchholz, Nov 30, 2004, in forum: Word VBA
    Replies:
    1
    Views:
    173
    Doug Robbins
    Dec 1, 2004
  5. Sean via OfficeKB.com

    Help with sub to change source file name for source links

    Sean via OfficeKB.com, Feb 22, 2005, in forum: Word VBA
    Replies:
    1
    Views:
    177
    Sean via OfficeKB.com
    Feb 22, 2005
  6. Jean Pereira
    Replies:
    4
    Views:
    89
    Jean Pereira
    Aug 21, 2008
  7. Orla
    Replies:
    0
    Views:
    282
  8. Ridge Kennedy

    Invisible Source - Word Merge Source

    Ridge Kennedy, Nov 7, 2008, in forum: Word VBA
    Replies:
    1
    Views:
    126
    Doug Robbins - Word MVP
    Nov 7, 2008
Loading...