News4 mins ago
Mail Merge help needed please
Can anybody help me - I have several mailmerges to do and am making address labels. I am using the Wizard from Word and Excel databases.
My problem is that some of the addresses on my lists have only 2 address fields plus the postcode field, others have 3 or 4 plus the postcode. So I have fields: Name, Company, Add1, Add2, Add3, Add4, P/Code.
How can I get the Wizard to ignore the blank fields in the shorter addresses and compress the printed label so that there aren't any gaps?
Any help would be greatly appreciated.
My problem is that some of the addresses on my lists have only 2 address fields plus the postcode field, others have 3 or 4 plus the postcode. So I have fields: Name, Company, Add1, Add2, Add3, Add4, P/Code.
How can I get the Wizard to ignore the blank fields in the shorter addresses and compress the printed label so that there aren't any gaps?
Any help would be greatly appreciated.
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by buttons77. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
My wife has a Excel spreadsheet with a lot of addresses and she bringsh tem into Word using Mail Merge.
These have varying types of addresses (3 line, 4 line, 5 line etc) and Word manages to lay them out correctly automatically.
She does not have to do any manual "sorting out" and there are no gaps.
These have varying types of addresses (3 line, 4 line, 5 line etc) and Word manages to lay them out correctly automatically.
She does not have to do any manual "sorting out" and there are no gaps.
1 to 2 of 2
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.