VBA to split into separate spreadsheets and email with Outlook template

[Holley]

Hello all! I am curious if a task is possible with VBA. I work with a huge spreadsheet that I would like to automate. The data under each client will need to be copied and saved to a new worksheet and then we email out individual worksheets using a template. There is an Outlook contact named with the client #. Would it be possible to save each and search outlook for the contact to email the spreadsheet to?

In the spreadsheet example, I would need to end up with 4 spreadsheets. One for each client # listed and then email it to that contact.

I hope I am explaining this clearly.

I don't mind putting the work in to get this going, just not sure if it is even doable.

Thanks in advance!!!

 

[Holley]

there are... this is just to test. My information is in the office and I would have to enter hundreds of dummy pieces of information. Is this not workable?

 

[Logit]

Ok ... let me work with this.

 

[Holley]

Ok ... let me work with this.

Thanks so much! Here is another "contact" list with entries that do not have matching data in the spreadsheet. Would be a more true test environment.

test2.xlsx
	A	B	C	D	E	F
1	Company / Private Person	Street Address	Postal Code	City	Contact Person	Email
2	1234				1234	holley@ab.com
3	4568				4568	holley@cd.com
4	987				987	holley@ef.com
5	6543				6543	holley@gh.com
6	9876				9876	holley@ij.com
7	5432				5432	holley@kl.com
Sheet1

 

[Logit]

What information are you including in the SUBJECT & MESSAGE ? Post an example ...

 

[Holley]

What information are you including in the SUBJECT & MESSAGE ? Post an example ...

 

[Logit]

Download finished workbook with instructions.

Email Data.xlsb

 

[Holley]

Download finished workbook with instructions.

Email Data.xlsb

Thank you! Our security blocks me from downloading. Can enter the code in the message?

 

[Logit]

There is a ton of code .... let me send you a private message.

 

[Holley]

There is a ton of code .... let me send you a private message.

Thank you!!

 

[Logit]

You are welcome. If you have any questions let me know.