MessageBox.Show( " T O T A L - M E S S A G E - S E N T = " + i,
Sleeps system for 1000ms for refreshing GSM Modem / Phone Pdu3 = new SmsSubmitPdu(MMessage, MSMS_Number, " ") MessageBox.Show( " Data Imported Successfully.!!!\r\n\nĬheck Imported Values & SEND SMS.!!!!",Įxcel FIle\r\n\nKindly Check Worksheet Name",Īfter loading Excel file into the DataGrid, we'll only use the For Loop function to get CELL NUMBER & MESSAGE one by one and send it using very simple code just like for sending a single SMS message.įor (i = 0 i < dataGridView1.RowCount - 1 i++)
Label25.Text = " Total SMS In Excel File " + rows_counting There Should Be Only Two Columns in Sheet Like Below\r\n\nĬELL NUMBER | MESSAGES", " Error", MessageBoxButtons.OK, MessageBox.Show( " Kindly Check Column Count Rows_counting = dataGridView1.RowCount - 1 Ĭolumn_counting1 = dataGridView1.ColumnCount OleDbDataAdapter dataAdapter = new OleDbDataAdapterĭataGridView1.DataSource = dataSet.Tables ĭataGridViewAutoSizeColumnsMode.DisplayedCells OpenFileDialog dialog = new OpenFileDialog $]", " SMS") Below code on button click will Open File Select Dialog Box // for Excel File which contains Sheet name SMS and only two columns named // CELL NUMBER and MESSAGES which will be loaded in to DataGridView // Also you need to rename your Excel sheet to SMS because // it is also checking that sheet name private void button3_Click_1( object sender, EventArgs e) Try GSMComm connection with the values got from the DataGrid when Cell is Clicked. As shown below, a Confirmation message will appear and Connected device information will also be shown and DataGrid Cell will be highlighted green. If you get all the COM Port Information from system without error, then the second step is to connect to the device, click on the Cell of Data Grid of your desired device to connect. Object connstatus = queryObj ĭ(capdeviceid, captionObj, New ManagementObjectSearcher( " root\\CIMV2",įoreach (ManagementObject queryObj in searcher.Get()) O Default CSV folder: where CSV Send command jumps in.// // Here we are getting the all available information from the Win32_SerialPort // and setting it in to the DataGrid try O Default CSV comma sign: CSV comma is included in your CSV file, please open with a text editor to know what is your seperator comma between a phone number and a message O Future Time Format: define format for future time keywords. O Save sent SMS to Inbox: If you send a batch of hundreds SMS, this may help you opt-out your SMS after sending! O Contact Selector: define how to select a number when a person has multiple numbers O Preview your CSV content: check to preview before sending (recommended) O Default Folder: path to your CSV folder, this improve file browsing O Encoding: depending on your file, default setting is "System Default" (recommended) Here is a sample file which works with following settings (by press Menu/Settings/CSV Settings/) csv file to preview SMS list before press "Send SMS" button. A CSV browse dialog will appear helps you to choose a. CSV file: In the main view, press menu button and select "Send from. When you please "send SMS" button, BulkSMS will ask you the value of a user defined macro. * User-defined macro: A macro start with $ sign and end by any of following sign " ?. O Please email me or comment on this page if you find any useful macro. O $first_name: Contact's first name defined in your address book O $name: Contact's name defined in your address book. O Add macro: During edit template, please menu button to add a pre-defined macro. O Add/delete/edit/edit title: focus on a template then press menu button, or press and hold a template in the list. * Template: In the main view, you will see a list of templates. Note that SMS fee is charged by your telephone operator! * Option to delivery report and save sent SMS to Inbox * Support pre-defined keyword: $name, $first_name, $now, $next5min, $next15min, $next30min, $next1hour, $next2hour, $tomorrow, $nextweek Please see a sample file in Help section below. TXT files and can configure according to your file format, typically compose from MS Excel. * Send to groups and individuals (very convenient with different choice in contact picker synced with Google contacts/groups, see setting for more info) Bulk SMs is designated to become "killer app" for texters and professional uses.
0 kommentar(er)
