Piano Forum

Topic: Mail Merge Help  (Read 1353 times)

Offline thalbergmad

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16741
Mail Merge Help
on: February 11, 2009, 08:51:12 PM
Oh Dear,

I am not very expert on Microsoft Word and had to do a large merge for a customer today for a mailshot.

The problem i had was that the amount of fields on the addresses ranged from 4 lines up to to 7 lines. On the addresses with only 4 lines, Word moved the text upwards so that the "Dear Customer" part of the letter was visible when the letter was folded and put into an envelope.

Does anyone know how to do a mail merge where the actual placing of the standard text remains static no matter how many fields in the address.

Any help would be appreciated.

Thal
Curator/Director
Concerto Preservation Society

Offline shortyshort

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 1228
Re: Mail Merge Help
Reply #1 on: February 13, 2009, 05:30:42 PM
I had the same problem a while back.

I made all the addresses the same amount of lines.

I chose 5.

You really only need the company name and the post code for it to get there.

Then use the other 3 lines for the rest of the address. (perhaps removing a line).

I'm sure that there is a proper way to solve your/our problem, but it worked for me.
If God really exists, then why haven't I got more fingers?

Offline thalbergmad

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16741
Re: Mail Merge Help
Reply #2 on: February 13, 2009, 05:53:25 PM
Thanks for your reply shorty, i like your solution. Some nice person on another forum solved this for me.

Should any one be remotely interested, all you need to do is create a text box around the address fields and make it invisible before you print.

Clever eh.

Thal
Curator/Director
Concerto Preservation Society

Offline shortyshort

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 1228
Re: Mail Merge Help
Reply #3 on: February 13, 2009, 06:00:10 PM
No probs.

I hate word myself.

I'm sure that I'll be needing your info below before this recession is over.
If God really exists, then why haven't I got more fingers?

Offline thalbergmad

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16741
Re: Mail Merge Help
Reply #4 on: February 13, 2009, 10:37:52 PM
I will be needing a bus pass before this recession is over.

Thal
Curator/Director
Concerto Preservation Society
For more information about this topic, click search below!
 

Logo light pianostreet.com - the website for classical pianists, piano teachers, students and piano music enthusiasts.

Subscribe for unlimited access

Sign up

Follow us

Piano Street Digicert