Piano Forum

Topic: Mail Merge Help  (Read 1420 times)

Offline thalbergmad

  • PS Silver Member
  • Sr. Member
  • ***
  • Posts: 16742
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: 16742
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: 16742
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!

Piano Street Magazine:
Cremona Musica’s Piano Experience 2024 – Constantly Evolving Perspectives

In the end of September, the annual Cremona Musica 2024 exhibition, a significant global event, takes place providing novel insights into the music industry. As a member of the Media Lounge, Piano Street is pleased to offer a pianistic perspective on key events. Read more
 

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