1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Please HELP! Mail Merge with Windows XP

Discussion in 'Business Applications' started by tamstafry, Oct 6, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. tamstafry

    tamstafry Thread Starter

    Joined:
    Oct 6, 2008
    Messages:
    1
    Hi,
    I am trying to do a mail merge from Excel to Word 2003 in Windows XP.....much harder than the old version. I am importing part numbers and two lines of description onto a formatted Word document.
    <<Product Reference>>
    <<Description Line 1>>
    <<Description Line 2>>

    There are 10 text boxes on the page containing the above info.

    I am able to get the merge completed, but it is showing a whole page of each part number, when I need only one of each.

    In Windows 98 you could put <<next_record>> in front of the second and succeeding merge fields and it would move onto the next record....now it comes up with an error and tells me I cant have the word NEXT in there.... I can't seem to make any sense out of it????? Yes, im blonde - but that shouldn't matter!

    Any help would be greatly appreciated

    Cheers
     
  2. Yorkshire Guy

    Yorkshire Guy

    Joined:
    Dec 9, 2003
    Messages:
    563
    Hi tamstafry,

    You are right, mail merge went messy when Bill changed it, and I don't believe there is an easy way to do what you want now.

    It can be done with macros and word field calculations but beyond the 'normal' word users experience (I tried it once and gave up).

    Here is a link to somethink that may help you, at a price!

    http://ukww.net/patools/excel/amomusd.htm

    Alternatively, if you can re-arrange your spreadsheet so that all the data for a Product is on one row, or make a new linked spreadsheet to that affect, then you don't need the above.

    lol
    Hew
     
  3. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    1. http://www.officearticles.com/word/mail_merge_letters_in_microsoft_word.htm may help

    2. "In Windows 98 you could put <<next_record>> in front of the second and succeeding merge fields and it would move onto the next record"

    Sounds like that would be pretty good if it still worked.

    Hew mentioned re-arranging your spreadsheet or or making "a new linked spreadsheet". That could be set up easily -- having a new worksheet with an area linked to your Word doc that updates by itself when you select a (different) product. Whether it would be practical depends on # of records and how you (have to) work.

    Maybe you could upload a copy of your workbook with all but a few lines deleted so we could see the actual structure. (?)

    Welcome to the board. :)
     
  4. MRdNk

    MRdNk

    Joined:
    Apr 7, 2007
    Messages:
    439
    Hi tamstafry,

    Welcome to the forums.

    - It really annoys me the way that they've changed Mail Merging for 2003, especially the way in which you have to re-select your data source each and every time. Ahhhhh!

    Oh Bill!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/756823

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice