Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Mail Merge Nightmare

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Wokingham, England
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    London, England
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •