emina002
07-08-2016, 04:15 PM
I am building a Userform where the user can freely compose email he/she wants,
I have a list box listed some field(source is from Sheet1 from Column C so on.. and I already set name range to it), to visualize my problem kindly download first the workbook attach within this thread.
From opening the workbook Sheet1 already visible with button Compose email, as you click that userform will be visible.
This workbook is sample only of my problem and not the really exact file(so sorry for the field and item name), it is more replicate of Mail Merge on word.
My problem is to code the ff. because I dont know how to start.
1. Is if the user type "Hello" followed by drag the column field "Name" listed on listbox supposed to be the value of Textbox now is "Hello Name", (I already did this but checked if I code it correctly)
2. When I check "Preview" it will change the value of "Hello Name1"(this is the first line item or record) on textbox and the "<<" ">>" button is previous and next record so when i press ">>" button it will show "Hello Name2" and so on, same with << button it will show the previous line item.(dont know how to start writing a code to call all item on Sheet1)
3. Previewing the item and next and previous button will be applicable also to TO and CC textbox field.(need also help on this)
I did this so the user can freely choose the field item he want to include when composing email. I already set a name range of the column header so the user can add many column header when needed before start composing email.
The purpose of this is to send bulk of email in one click with the standard email compose by the user. User can used mail merge on word but no CC recipient field available, and also ease for the user to add or delete line item not to include on sending emails.
Hope you can help, feel free to ask for additional question, I hope I explained it well. Thanks in advance :)
I have a list box listed some field(source is from Sheet1 from Column C so on.. and I already set name range to it), to visualize my problem kindly download first the workbook attach within this thread.
From opening the workbook Sheet1 already visible with button Compose email, as you click that userform will be visible.
This workbook is sample only of my problem and not the really exact file(so sorry for the field and item name), it is more replicate of Mail Merge on word.
My problem is to code the ff. because I dont know how to start.
1. Is if the user type "Hello" followed by drag the column field "Name" listed on listbox supposed to be the value of Textbox now is "Hello Name", (I already did this but checked if I code it correctly)
2. When I check "Preview" it will change the value of "Hello Name1"(this is the first line item or record) on textbox and the "<<" ">>" button is previous and next record so when i press ">>" button it will show "Hello Name2" and so on, same with << button it will show the previous line item.(dont know how to start writing a code to call all item on Sheet1)
3. Previewing the item and next and previous button will be applicable also to TO and CC textbox field.(need also help on this)
I did this so the user can freely choose the field item he want to include when composing email. I already set a name range of the column header so the user can add many column header when needed before start composing email.
The purpose of this is to send bulk of email in one click with the standard email compose by the user. User can used mail merge on word but no CC recipient field available, and also ease for the user to add or delete line item not to include on sending emails.
Hope you can help, feel free to ask for additional question, I hope I explained it well. Thanks in advance :)