+ Reply to Thread
Results 1 to 4 of 4

Write macro to fill body of the text automatically

  1. #1
    Registered User
    Join Date
    03-13-2011
    Location
    GE
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Write macro to fill body of the text automatically

    Hello every one

    I need your help and advice.


    You have to send specific templates to my clients asking them to fill out the specific info. The problem is that sometimes that forget to fill it completely, or make mistakes.

    Is it possible to write a macro that will open up a new window containing name of the information and message boxes that should be filled. When the message boxes are filed, texted entered there will automatically be inserted in the body of the whole text.

    For e.g. if I enter name of a person Jon Smith, this name is automatically inserted in the body of the message. (Please view attachment to obtain better understanding what I mean).


    Those fields that are marked in yellow should be filled automatically.

    Please review my attachment and tell me if performing these procedures are possible.

    Thank you all very much!!!!! I appreciate your help and support
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,309

    Re: Write macro to fill body of the text automatically

    I'm pretty sure that Word has a Mail Merge Wizard that can take you through this type of process.

  3. #3
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,835

    Re: Write macro to fill body of the text automatically

    If these letters are being produced in bulk and you have all the relevant data stored somewhere (in a database or Excel workbook, for example), you could use Word's mailmerge facility. otherwise, you can configure the document as a form (see http://gregmaxey.mvps.org/word_tip_p...ting_data.html).
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Registered User
    Join Date
    03-13-2011
    Location
    GE
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Write macro to fill body of the text automatically

    Yes yes thank you macropod the you've set is just what I want. Dangalor thank you also for a quick help and timely response.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1