Text Messaging Bulk
Updated on
1. Obtain phone numbers from a list.
2. Copy the phone numbers to a google sheet. Follow the steps below.
- Copy to a spreadsheet
- Remove the hyphens.
- Select the column of numbers
- Goto Edit --> Find and Replace
- Under 'Find', type -
- Click 'Replace all'
- Append a semicolon.
- In the next column, type, =A1&";"
- Hit enter.
- Copy the formula down.
- Transpose from a column to a row.
- Select the cells.
- Cmd (control) C to copy.
- In the next column, Right Click, paste values only!!!
- Cmd (control) C to copy.
- Click an empty row and right click.
- Paste Special --> Paste Transposed
3. Add to your Notes application on your mac laptop.
- Copy the row from the previous step into Notes
- Click the Messages icon.
- Cut the list from the messages and add to the recipients space.
- Add a message and send.
