View Single Post
  #1   Report Post  
kim
 
Posts: n/a
Default Merge from outlook and excel

Hi
I need to do a mail merge to deliver an e-mail to our personnel.
Problem is the variable data for the letter is in a excel worksheet it shows
the 3 columns as:
[old salary scale] [new salary scale] [ staff number}
I need it to pull the individdual data from here to insert in the mail merge
letter.

I then need to e-mail in a mass mailing but all the email addresses are
stored in the Outlook 2002 global address book. I can only call up the
contacts folder.
It seems I need to use the 2 data sources or try and get the Global address
book into the excel doc.
Can anyone please advise a way to go on this I am desperate!
Thanks