AT&T Step Processes: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== No Customization == # Load list in Excel and check email column for duplicates and remove all duplicates # Upload list to TM # Export the report of UnSubs (this will create the PreUnSub list == Customizations == === Last 4 Digits of Ban == # Load list in Excel and create a new column # in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers # Use the new column when uploading to TM for the BAN number === Combining N...") |
|||
| Line 14: | Line 14: | ||
# for large amounts you might need a formulate similar to below: | # for large amounts you might need a formulate similar to below: | ||
`=INDEX($D$2:$F$5, INT((COLUMN()-COLUMN($G$1))/COLUMNS($D$2:$F$5))+1, MOD((COLUMN()-COLUMN($G$1)), COLUMNS($D$2:$F$5))+1)` | |||
Revision as of 12:27, 17 February 2025
No Customization
- Load list in Excel and check email column for duplicates and remove all duplicates
- Upload list to TM
- Export the report of UnSubs (this will create the PreUnSub list
Customizations
= Last 4 Digits of Ban
- Load list in Excel and create a new column
- in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers
- Use the new column when uploading to TM for the BAN number
Combining Numbers to One line
- if it is a small amount you can copy and paste
- for large amounts you might need a formulate similar to below:
`=INDEX($D$2:$F$5, INT((COLUMN()-COLUMN($G$1))/COLUMNS($D$2:$F$5))+1, MOD((COLUMN()-COLUMN($G$1)), COLUMNS($D$2:$F$5))+1)`