Replies

Thanks, Hans: the answer is ‘no’. I’ve looked, but can see no systematic difference in structure’

Thanks, Hans: the answer is ‘no’. I’ve looked, but can see no systematic difference in structure’

Thanks very much, both

Thanks very much, both

Hi, Rudi –
>>Is this correct or just a typo….should it not be ??? Do you have a field called in the source data file?
This is correct.
It’s to handle politely people like clergymen, where the address might say ‘The Revd….’ but the letter would start ‘Dear Fr. …..’
Hence two title fields, mostly identical but sometimes not.

Wendell – I’ll examine your reply when I get the chance. Will also try it as an .xls or something.
But it always worked ok with Word 97!

Thanks, both.

Hi, Rudi –
>>Is this correct or just a typo….should it not be ??? Do you have a field called in the source data file?
This is correct.
It’s to handle politely people like clergymen, where the address might say ‘The Revd….’ but the letter would start ‘Dear Fr. …..’
Hence two title fields, mostly identical but sometimes not.

Wendell – I’ll examine your reply when I get the chance. Will also try it as an .xls or something.
But it always worked ok with Word 97!

Thanks, both.

And if you wanted a space between the initials,
=(Left(A2,1)&” “&Left(B2,1))

And if you wanted a space between the initials,
=(Left(A2,1)&” “&Left(B2,1))

Many thanks to all four of you for some very useful leads. Sorry about the delayed thanks.
Steve’s trick to ‘freeze’ links is imaginative and simple – great trick, Steve!
Andrew’s patient exegesis on MS Query was exactly what I needed to ‘break the ice’.
With help from Legare and Chipshot too, I now have more than one way of frying this particular set of eggs, and I’m very grateful.

Many thanks to all four of you for some very useful leads. Sorry about the delayed thanks.
Steve’s trick to ‘freeze’ links is imaginative and simple – great trick, Steve!
Andrew’s patient exegesis on MS Query was exactly what I needed to ‘break the ice’.
With help from Legare and Chipshot too, I now have more than one way of frying this particular set of eggs, and I’m very grateful.

That’s correct, Legare – thanks for mindreading me!
I’m uneager to use links as some of the workbooks ‘refreshed’ with data from the ‘external’ source need to be sent to other people and I’d rather send just one updated copy of a single file than all the linked files it’s getting gen from.
Is this the sort of case where the get external data route makes sense?
BTW, this message probably says it’s from itsimagain. I’m the same grateful lounger as jrose. So doubly grateful for all the skill and patience available here.

That’s correct, Legare – thanks for mindreading me!
I’m uneager to use links as some of the workbooks ‘refreshed’ with data from the ‘external’ source need to be sent to other people and I’d rather send just one updated copy of a single file than all the linked files it’s getting gen from.
Is this the sort of case where the get external data route makes sense?
BTW, this message probably says it’s from itsimagain. I’m the same grateful lounger as jrose. So doubly grateful for all the skill and patience available here.

Agreed on most of this, but sometimes with some pages it cuts off the right-hand ends of lines of text: setting page setup as landscape ‘cures’ this.
Might be down to bad page design?

Agreed on most of this, but sometimes with some pages it cuts off the right-hand ends of lines of text: setting page setup as landscape ‘cures’ this.
Might be down to bad page design?

and to make it less hard to mend when someone breaks it, I’ve replaced the mystery $$$$$ with named ranges – just need to put new members ‘in the middle’ rather than at the end!