PaultheITGuy
Technical User
Hi,
I wonder if you can help. I have set up a mail merge using Publisher, with Excel as the data source. it's a simple address labels one.
I know how to get the merge to remove empty lines when fields are empty, but I cannot get it to remove empty spaces when there are more than one field on a line.
For example: The spreadsheet contains the following fields - "Title", "First name(s)" and "Surname". The merge in Publisher shows "<<Title>> <<First name(s)>> <<Surname>>" but if the recipient does not have a title or first name then it can come out like this: " John Smith", "Mr Smith".
How do I remove these pesky spaces?
Thanks in advance
PC
PS - Publisher and Excel 2003, Windows 2000. Ta.
I wonder if you can help. I have set up a mail merge using Publisher, with Excel as the data source. it's a simple address labels one.
I know how to get the merge to remove empty lines when fields are empty, but I cannot get it to remove empty spaces when there are more than one field on a line.
For example: The spreadsheet contains the following fields - "Title", "First name(s)" and "Surname". The merge in Publisher shows "<<Title>> <<First name(s)>> <<Surname>>" but if the recipient does not have a title or first name then it can come out like this: " John Smith", "Mr Smith".
How do I remove these pesky spaces?
Thanks in advance
PC
PS - Publisher and Excel 2003, Windows 2000. Ta.
