Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excell Mail Merge


  • Please log in to reply

#1
clarity

clarity

    New Member

  • Member
  • Pip
  • 2 posts
Hi have imported dated from access to an excell spread sheet for mail merge to word document. All merged ok and looked fine on screen.

When printed the letter L has appeared after every letter between the first and last name.

Spread sheet is split into columns with Title, first Name, Surname, Address, Post (zip) code

can you help me get rid of this error
  • 0

Advertisements


#2
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts

Hi have imported dated from access to an excell spread sheet for mail merge to word document. All merged ok and looked fine on screen.

When printed the letter L has appeared after every letter between the first and last name.

Spread sheet is split into columns with Title, first Name, Surname, Address, Post (zip) code

can you help me get rid of this error


Has it appeared on it's own separate line, or appended to an existing one?

Are all the columns visible on your spreadsheet?

Make sure all column widths are fully expanded to the width of the contents.

Can you see this 'L' on Print Preview?

Edited by Jonesey, 19 September 2008 - 03:54 AM.

  • 0

#3
clarity

clarity

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Hi there

the L does not appear in print preview. I will run a small sample again with all lines expanded.

The l appears on the same line as the persons name i.e

Mr Adam Smith is on the print preview

Mr Adaml Smith appears on the actual print

Thanks
  • 0

#4
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts

Hi there

the L does not appear in print preview. I will run a small sample again with all lines expanded.

The l appears on the same line as the persons name i.e

Mr Adam Smith is on the print preview

Mr Adaml Smith appears on the actual print

Thanks



I have a feeling that's some sort of character that's been appended to the forename when it was imported into Excel.

Go to an empty column.

In this column , type in =right(A1,1)

Substitute A1 for whatever cell contains your forename

What do you get? It'll either be the 'l' you're seeing, or the actual last letter.

Edited by Jonesey, 19 September 2008 - 06:32 AM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP