Mail Merge Nightmare

[The Mad Druid]

I was hoping somebody would know how to do this....
I have an imported file from another program, in column b is the name of each person I want to contact and in column a, c and d is the data I want to send to them. However, the formatting of the imported file means that if a name is in b1 then the data to send will be in rows 2, 3, etc. Until the next name in column 2! What makes it worse is that the names are in 'Mr john Smith' format and the address book in outlook is in 'Smith, John' format. I spend way too long doing what should be a simple thing where I should just be able to mail merge or something in order to get it to scan for names and mail each the relevant data. Can anybody help please?

 

[Marcus]

Alright Chief,

Not sure about this one as I said the other day, but you got me thinking about other useful stuff that may help you. Look at http://www.asap-utilities.com to download a pretty funky add-on for Excel that makes rather handy formatting weapon.
This message was edited by Marcus on 2002-04-03 02:53

 

[AJ]

Hey Mad Druid,

I read this earlier but have been a bit pushed today to find the time to formulate a decent reply. This does sound though like very much the sort of thing I've had to do in the past.
Assuming your output of preference would be one row on a spreadsheet per respondent, then I reckon I could give you a macro to do the job.
If you send me the file (email below), I'll post a reply later/in the morning.

Rgds
AJ