Email data based on .CSV cell value

[seanbrown01]

I've been hacking at this for a few days now without success. Any help is greatly appreciated!

I have a .csv file with numberous rows of data. I would like to somehow email the rows of data, containing the same ID# in column one, to a specific email address. I'm also unsure of the best way to assign email addresses to each ID#.

If there is a way to specify which columns in each row will be emaild, based on ID#, that would be even better. I have attached the .csv file for reference.


Thanks!
Sean

[trentonponder]

Originally Posted by seanbrown01

I've been hacking at this for a few days now without success. Any help is greatly appreciated!

I have a .csv file with numberous rows of data. I would like to somehow email the rows of data, containing the same ID# in column one, to a specific email address. I'm also unsure of the best way to assign email addresses to each ID#.

If there is a way to specify which columns in each row will be emaild, based on ID#, that would be even better. I have attached the .csv file for reference.


Thanks!
Sean

I`m not quite sure I understand your objective. If you want to email different people with the data contained in your .csv file then you can loop through each row of the Excel doc and use the values to email.

Where are the email addressees? What kind of logic are you using to decide if everything should be sent?

[seanbrown01]

Originally Posted by trentonponder

I`m not quite sure I understand your objective. If you want to email different people with the data contained in your .csv file then you can loop through each row of the Excel doc and use the values to email.

Where are the email addressees? What kind of logic are you using to decide if everything should be sent?

I'm trying to get all rows with the same ID# into an email. Is it possible to match the ID# to an email address in a variable list?

[trentonponder]

Originally Posted by seanbrown01

I'm trying to get all rows with the same ID# into an email. Is it possible to match the ID# to an email address in a variable list?

So, the email address is also an ID#? I`m sorry but you`re just not being clear on what it is you`re trying to do.

[forumstaff]

Hi,

If we are understanding you in the right manner, we understand that you have a set of ID# in a csv which you want to compare and send to a specific e-mail address.

Can you advise the criteria for comparing the ID#. We want to know with what are you trying to compare the ID# and check if they happen to be same or not.

If you are looking to compare the ID# with certain e-mail addresses, can you send us an updated csv which contains the ID# as well as the e-mail addresses.

Kindly advise.