Mail Merge Nightmare

The Mad Druid · Apr 3rd, 2002, 01:58 AM

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 · Apr 3rd, 2002, 03:50 AM

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 · Apr 3rd, 2002, 08:15 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 01:58 AM	#1
The Mad Druid New Member Join Date: Apr 2002 Location: Wokingham, England Posts: 2	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?

Apr 3rd, 2002, 03:50 AM	#2
Marcus New Member Join Date: Mar 2002 Location: London, England Posts: 37	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 ]

Apr 3rd, 2002, 08:15 AM	#3
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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