vermilion
05-26-2011, 05:54 PM
Hi, new to VBA, have two questions.
As background, I am working with a large spreadsheet with hundreds of clients and info for each client. I am trying to do the following:
(1) Find email addresses and compose an email to the recipient. I have found macros to create the email using the address, I just need the code to, essentially, search the column for the next email address (the column does NOT consist solely of email addressess... if that would make things easier, I may be able to modify the spreadsheet).
(2) The Client's names are listed Lastname, Firstname. When I send emails, I address the clients by their first name only. I need a way to extract the first name from the cell containing their "lastname, firstname" and subsequently enter it in the text of the email.
Thanks in advance for the help. If you need any clarification, please let me know and I'll do what I can.
As background, I am working with a large spreadsheet with hundreds of clients and info for each client. I am trying to do the following:
(1) Find email addresses and compose an email to the recipient. I have found macros to create the email using the address, I just need the code to, essentially, search the column for the next email address (the column does NOT consist solely of email addressess... if that would make things easier, I may be able to modify the spreadsheet).
(2) The Client's names are listed Lastname, Firstname. When I send emails, I address the clients by their first name only. I need a way to extract the first name from the cell containing their "lastname, firstname" and subsequently enter it in the text of the email.
Thanks in advance for the help. If you need any clarification, please let me know and I'll do what I can.