+ Post New Thread
Results 1 to 6 of 6
Windows Thread, Mail Merge Office 2003 in Technical; Hi, One of our Admin lasses is having problems with mail merge in Office 2003. When she does the merge, ...
  1. #1

    Join Date
    Apr 2007
    Location
    York
    Posts
    560
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    20

    Mail Merge Office 2003

    Hi,
    One of our Admin lasses is having problems with mail merge in Office 2003. When she does the merge, any address with a letter in the house number, eg 12A , they appear in the letter as 0. All other numbers work fine.
    Any ideas?

  2. #2

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    11,211
    Thank Post
    1,809
    Thanked 2,223 Times in 1,641 Posts
    Rep Power
    803

    Re: Mail Merge Office 2003

    I presume your data table is in Excel?

    It is worth that all the cells in this column have the same data type:
    Format>Cell - choose Text rather than General.

    Lin

  3. #3

    Join Date
    Apr 2007
    Location
    York
    Posts
    560
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    20

    Re: Mail Merge Office 2003

    Yeah the data is in Excel, exported from Sims.net.

    No joy after changing the column to text though.

    Karl

  4. #4

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    11,211
    Thank Post
    1,809
    Thanked 2,223 Times in 1,641 Posts
    Rep Power
    803

    Re: Mail Merge Office 2003

    I will have a play and get back to you...


    You have probably already checked the data table... but in case you haven't; you need to check the data table to see if SIMS has exported the house numbers OK.

    Are Post Codes OK?

  5. #5

    Join Date
    Apr 2007
    Location
    York
    Posts
    560
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    20

    Re: Mail Merge Office 2003

    Thanks.

    Yeah the data in the data sheet is OK, inc Postocdes and house numbers

  6. #6
    KarlGoddard's Avatar
    Join Date
    Jul 2005
    Location
    Bolton, Lancashire
    Posts
    272
    Thank Post
    37
    Thanked 18 Times in 18 Posts
    Rep Power
    25

    Re: Mail Merge Office 2003

    We've had this exact same problem...

    Is the first cell of the column in question a number? If so put an apostrophe before the number and see if that solves it.

    Even though we formatted the cells in that particular column to text the error still occurred. Adding the apostrophe solved it.

    The error looks like Word seems to ignore the cell formatting and id's the cell value as a number then parses the rest of that column as the same format.

    Quite odd really

    HTH
    Karl

SHARE:
+ Post New Thread

Similar Threads

  1. Mail merge and pictures
    By GrumbleDook in forum Educational Software
    Replies: 11
    Last Post: 4th February 2009, 11:13 AM
  2. Running Office 2003 and Office 2007
    By mrforgetful in forum Office Software
    Replies: 17
    Last Post: 12th June 2008, 01:11 PM
  3. Mail Merge
    By Teaboy in forum MIS Systems
    Replies: 4
    Last Post: 12th November 2007, 06:32 PM
  4. Replies: 6
    Last Post: 28th September 2006, 07:06 PM
  5. Mail Merge with Office 2003
    By luke213 in forum Windows
    Replies: 1
    Last Post: 19th January 2006, 10:33 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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