+ Reply to Thread
Results 1 to 3 of 3

ex: 100 names on a list with other info --> 100 letter without pasting names and info

  1. #1
    Registered User
    Join Date
    12-20-2013
    Location
    laguna, philippines
    MS-Off Ver
    Excel 2003
    Posts
    1

    ex: 100 names on a list with other info --> 100 letter without pasting names and info

    lets say i have 500 names on a list with their age, address and other information

    then i would make an identical letter for them.. changing only the names and other information according to the data i have

    is there and easier way rather than pasting all their names one by one on a letter?

    if there is... thank you very much
    if there isn't ... got to do it the hard way haha

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: ex: 100 names on a list with other info --> 100 letter without pasting names and info

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: ex: 100 names on a list with other info --> 100 letter without pasting names and info

    Hi sefero,

    Microsoft Word has a feature called Mail Merge which will take the Names & Addresses from the spreadsheet & will paste them into a standard letter.

    Have a look at some information on Mail Merge.

    Hth
    Remember you are unique, like everyone else

+ 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. adding two new columns ov info depending if names are correct
    By Blaino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2012, 07:53 AM
  2. Using names to locate info
    By loJic in forum Excel General
    Replies: 8
    Last Post: 09-30-2009, 09:55 PM
  3. edit macro that is pasting info to check column for duplicate info
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2009, 05:55 PM
  4. Replies: 8
    Last Post: 02-05-2009, 09:08 PM
  5. Replies: 1
    Last Post: 03-22-2006, 11:50 AM

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