Home
Piano Music
Piano Music Library
Top composers »
Bach
Beethoven
Brahms
Chopin
Debussy
Grieg
Haydn
Mendelssohn
Mozart
Liszt
Prokofiev
Rachmaninoff
Ravel
Schubert
Schumann
Scriabin
All composers »
All composers
All pieces
Search pieces
Recommended Pieces
Audiovisual Study Tool
Instructive Editions
Recordings
PS Editions
Recent additions
Free piano sheet music
News & Articles
PS Magazine
News flash
New albums
Livestreams
Article index
Piano Forum
Resources
Music dictionary
E-books
Manuscripts
Links
Mobile
About
About PS
Help & FAQ
Contact
Forum rules
Pricing
Log in
Sign up
Piano Forum
Home
Help
Search
Piano Forum
»
Non Piano Board
»
Anything but piano
»
Mail Merge Help
Print
Pages: [
1
]
Go Down
Topic: Mail Merge Help
(Read 1353 times)
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
Logged
Curator/Director
Concerto Preservation Society
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.
Logged
If God really exists, then why haven't I got more fingers?
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
Logged
Curator/Director
Concerto Preservation Society
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.
Logged
If God really exists, then why haven't I got more fingers?
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
Logged
Curator/Director
Concerto Preservation Society
Sign-up to post reply
Print
Pages: [
1
]
Go Up
For more information about this topic, click search below!
Search on Piano Street