Individual Attachments (Outlook 2010)

Hello all, I've got a bit of a problem with a spreadsheet (Excel 2010) and some VBA that I want to add to it:

The spreadsheet contains client data like the below:

	A	B	C	D	E	F	G	H
1	Account Manager	Contact	Title	Surname	Email	Provider	Product	Reference
2	John Sheridan	Davey Jones	Mr	Jones	[email protected]	ABC Ltd	Plan XYZ	123456
3	Londo Mollari	Janet Fabricated	Ms	Fabricated	[email protected]	DEF Plc	Plan UVW	742589

What I'm trying to get from this is a personally addressed email with 2 attachments, one will be standard to all recipients and one will be unique and specific to that recipient. The filename of the unique attachment will contain the reference but will have some other stuff in the filename as well on either side that I will not be able to remove.

In terms of the file locations the unique ones will be in subfolders of the folder holding this workbook and the generic one will be in the same folder as the this workbook.

This is some adapted code that solved a similar problem (in Excel 2007 though) on a different website.

Please Login or Register  to view this content.

In that case the file started with the "reference" field but in my case it is in the middle and the formats vary depending on the provider, there will only be a maximum of 5 providers but I would like to avoid 5 different macros if at all possible so I need a search function of some sort.

If anyone can help with this I would be extremely grateful!