I have a table with 10 columns of data. (LastName, FirstName, StreetNo, Street, Unit, city, Prov, PostCode, Telephone, Email). Currently there are 77 rows of data in the table.
I am using userforms for the benefit of the end users who have no experience with Excel.

The first form is used as a main menu. This form contains command buttons that perform various tasks. For example, one command button, when clicked, open a data entry for the user to add a new record to the table. Another command button automatically exports the table data to a pdf document.

I want to use a third command button to take (A)LastName, (B)FirstName, (J)Email and export the data to a csv text file. This file will allow the user to import the information into other applications such as an email client. Since the table data is not static, I need to make sure that any added records are included in the exported file. In addition, not all names in the table have an email address so I need to eliminate the records with a blank email cell.

I have found many code samples for this but I cannot get any of it to work for me. If anyone can help me with this, I would be very grateful. I am quite familiar with relational databases such as Access however my end user has requested that the data be maintained in excel. I am somewhat familiar with writing mathematical formulas in excel but manipulating text data with vba code is new to me.