Thread Tools Display Modes
  #1   Report Post  
LotusN LotusN is offline
Junior Member
Posts: 1
Default Formatting problem of Mailmerge data in Word

Hi all,

after searching both at this and and other forums to no avail I decided to post a question. I have a Mailmerge set up from Excel (directory) and it populates invoices and it produces one invoice per family. It has a different number of family members for each invoice but everything works, every family start with a new invoice. The problem I have is that depending on the length of the names the individual table records are not aligned in columns. It might look like this,

Lars Svensson M-nr: 1000 Avgift: 300:-
Anna-Magdalena Svensson M-nr: 1001 Avgift: 300:-

I want the names as they are but the M-nr: and Avgift: should start at the same position.

I have tried several things like adding blanks after the names in the Excel sheet so that every name has the same length, setting a specific length on the Excel cell, using a fixed width font as Courier etc. Nothing works. Is it a way to dynamically add one or two tabs depending on the length of the names?

I am using Word and Excel 2010.


Last edited by LotusN : November 16th 15 at 02:39 PM
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge data with Word 2007 jlogco Mailmerge 1 June 5th 09 03:29 AM
Data source for mailmerge not selecting all data - PLEASE help! Katie Mailmerge 3 October 28th 08 06:12 AM
Excel data formatting change on Mailmerge watchtower Mailmerge 1 January 9th 07 03:35 PM
Mailmerge on word using excel data RJP Mailmerge 4 April 11th 05 08:29 AM
Formatting a word mailmerge with Excel data source Tracey Mailmerge 2 March 15th 05 02:07 PM

All times are GMT +1. The time now is 04:50 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"