+ Reply to Thread
Results 1 to 2 of 2

How to generate letters as attached

  1. #1
    Registered User
    Join Date
    12-01-2004
    Posts
    70

    How to generate letters as attached

    Hi all,

    Could someone help me with this to generate letters as in Test Final Result Sent.
    I have a Excel spreadsheet with some data and that data need to be used to generate a letters as in Test Final result Sent. The content will be same, but School name, address and the Student names change. I am not good at programming, if someone can write a program that will help a lot.

    Thank you so much
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How to generate letters as attached

    I think that this is the wrong approach. You should be using Mail Merge.

    Your Data is in Excel which is good.

    Open your Text File using Microsoft Merge.

    Select the mailings tab and then select "Select Recipients" select use existing list and browse to select your data.

    Then scroll through your letter and select all your data that appears in your database

    Highlight the data, then Select the mailings tab and then select "Insert Merge Field"

    Once you are done

    Select the mailings tab and then select "Start Mail Merge"

    Good Luck.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate every value between two values (letters and numbers)
    By benexclaimed in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-04-2024, 04:54 PM
  2. hello, generate all combinations of at most 3 by letters,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2019, 07:19 PM
  3. [SOLVED] Request = generate the maximum formations 3 letters of the 10 letters
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2017, 09:20 PM
  4. [SOLVED] Sum values attached to letters
    By CoachK88 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-23-2017, 03:43 PM
  5. Generate all possible combinations between 3 letters
    By rcprito in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-18-2015, 05:47 PM
  6. Can I use a Macro to generate a report for this spreadsheet as attached?
    By conks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2013, 04:39 PM
  7. Rounding a number with letters attached
    By tlewis in forum Excel General
    Replies: 4
    Last Post: 05-07-2009, 11:37 PM

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