Mail Merge + XP settings

[DaveSS]

Hi Folks,

We've upgraded to Office XP in an office. We use Mail merge with Word and excel a lot.

I've noticed that MS have changed Mailmerge to a wizard. Which in theory is quite easy. However as we are based in Europe I am having problems allocating address lines.

We basically have address 1, 2,3,4,5. And do not have things like State, or postal code.

Word gives you the option of associating your own field names to it's ones ie Address 4 can be related to Postcode. However I am still having problems with this as

1. You have to do this everytime you do a merge, and showing a multitude of staff this is a serious pain.

3. It still ends up with long address, as displaying up to two fields per line: particularily the last line.

Does anyone have a solution to this.

Or is there a way of not using the wizard. I now you can edit in field names individually through the wizard, but this is a very slow process.

Thanks

Dave

 

[XL Guru]

Dave,

see if Dreamboat's stuff at

http://www.theofficeexperts.com/word.htm#MailMergeWordXP

covers it.

HTH,
Andy

 

[DaveSS]

Andy,

Thanks for that. Unfortuately what they are suggesting there is very awkward, as inserting the fields this way means inserting a field, clicking close on the "insert" window, inserting a space, going back into edit, clicking the next field and so on. While providing an accurate solution, it's still painful in implement!

I don't get why MS didn't leave the old method open!!?!!!
Dave

 

[jbcalg]

lol
yes, just experienced the pain myself last night setting up an 'easy' merge.

next time i'll just use Office 2000 on the other machine - Office XP is a little too clunky for this