Re: "remove blank lines"+"Mail Merge"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In Word 2007 the option is set to "Don't print blank lines" by default.

But you can modify the setting either by putting the old Mail Merge Helper in the QAT (Word Office Button->Word Options->Customize->Choose commands from All Commands, locate Mail Merge Helper and drag it to the right hand column) and using the third button, or by using VBA to issue

activedocument.MailMerge.SuppressBlankLines = True

(or False!)

> Thanks. I tried both and I got 'closer' but MS Word 2007 wouldn't always
> line the data up properly and other times it would throw an additional '$' on
> the line.

Do you actually have a variety of different formats of amount in your data source (e.g. some with just 1.23, some with $1.23, etc.?)


Peter Jamieson

http://tips.pjmsn.me.uk

John wrote:
Peter and macropod,

Thanks. I tried both and I got 'closer' but MS Word 2007 wouldn't always line the data up properly and other times it would throw an additional '$' on the line.

I've seen several posts about a feature that perhaps other (prior) versions of MS Word had and either 2007 hides it or I just can't find it. The feature I wanted to try was a switch that said "Don't print blank lines". I've searched high and low and can't seem to find that switch. I'm not saying it would solve my problem but I would like to turn it on (if it exists in MS Word 2007).

Many thanks.
.

Relevant Pages

  • Re: "remove blank lines"+"Mail Merge"
    ... commands from All Commands, locate Mail Merge Helper and drag it to the ... I've seen several posts about a feature that perhaps other versions ... I wanted to try was a switch that said "Don't print blank lines". ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Does Handling Matter?
    ... the working of the radio/CD player, which has a feature that I do not like. ... Anyhow the feature I don't like is the arrangement whereby I am limited to 30 minutes of radio/CD player usage unless the engine is running. ... Given that I'm retired and very fond of music and the countryside, I used to like to take the car out to a nice spot and settle down to a bit of CD enjoyment or reading. ... The stupidity of it is emphasised when you bear in mind that after 30 minutes the radio/CD player stops working, but I could switch on all the lights and have wipers, washers and electric windows working all afternoon - with no time limit whatsoever on their functioning. ...
    (uk.rec.driving)
  • Software architecture using C for mid-range PIC.
    ... The application is probably fairly typical - inputs / commands ... Incoming comms will run ... checksum byte, in pseudo-code, something like this: ... switch { ...
    (comp.arch.embedded)
  • Re: Software architecture using C for mid-range PIC.
    ... The application is probably fairly typical - inputs / commands come in via the UART, peripheral devices need to be turned on and off in response, other devices need to be queried via I2C ... switch { ... The above pseudo-code is just meant to give an idea of where I'm heading, so don't take it too seriously. ... The interrupt usually should do as little as possible there are only two so they have to share. ...
    (comp.arch.embedded)
  • Re: Reintroducing fish, the friendly interactive shell
    ... Kurt Swanson skrev: ... the writers of all the commands to implement this would be infeasible. ... specific switch, in which case val and flag must also be 0. ... int has_arg; ...
    (comp.unix.shell)