E-mail merge with unique attachments

[Uptickdk]

I am using Outlook 2010 and need to send out 100+ emails with the same text (accept for the salutation but if not possible can read "Dear Client") and each email needs to have a unique pdf attachment based on the receiver. I.E sending each client an invoice for the month.

the "invoices" are all in one file and titled by last name then date i.e "smith 07052012.pdf" all the contacts are in outlook's contacts and I have created a spreadsheet based with Column A= last name Column B=email address.

Can not seem to get get Outlook to read spreadsheet and attach file.

Any help would be greatly appreciated.

Uptickdk
Call with FONcall™
[phone] (javascript:void(1);)
Connecting
Connected
Call failed
bug? (javascript:void(1))

[JP2112]

Using VBA, Outlook can open a workbook, read worksheet values and create a unique email for each record, effectively performing a mail merge on worksheet data. Do you have any code written so far?

Also, those links in your signature are broken. FYI.