AT&T Step Processes

From MEG Client Production Guide
Revision as of 12:27, 17 February 2025 by Cgrant (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

No Customization

  1. Load list in Excel and check email column for duplicates and remove all duplicates
  2. Upload list to TM
  3. Export the report of UnSubs (this will create the PreUnSub list

Customizations

= Last 4 Digits of Ban

  1. Load list in Excel and create a new column
  2. in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers
  3. Use the new column when uploading to TM for the BAN number

Combining Numbers to One line

  1. if it is a small amount you can copy and paste
  2. 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)```

Retrieved from "http://guide.medgeclients.com/index.php?title=AT%26T_Step_Processes&oldid=681"