LTT Engine Room · Internal
LER Contact Pilot
Generate, archive, reconcile & batch-map contacts.
v4
19-Jun-26
LERContactPilot-App.HTML
LTT Outsourced CFO Sdn. Bhd.
New contact
Build the standard contact line for the Google Contacts First name field.
1Category of contact
2Ref / ID
3Salutation
4Full name
5Entity short name
6Type of entity
7Company / Organisation (full name)
8Role / Title
9Mobile (primary)
10Alt phone (not in line)
11Email (not in line)
12Contact remarks
13First-contact date
Contact archive
Loading…
Cross-check accounts
Export each account's contacts (Google Contacts → Export → Google CSV / vCard; Outlook / 365 → Export contacts → CSV) and drop them in. Matched locally by mobile number — nothing leaves this page.
Done
Batch edit & map to Google Contacts
Import a file (e.g. an Office 365 export), map its columns to the fields you use in Google Contacts, edit in bulk, then download a Google-ready CSV. First name is built as your standard contact line.
Source file
Office 365 / Google / any CSV or vCard
No file loaded
Change log & format notes
- Contact Pilot - v4 - App.HTML - 19-Jun-26 — Moved into the LTT Engine Room series with the LER steel masthead and a tabbed layout. Added Batch edit: import a file, map columns to the Google Contacts fields in use (First name = standard line, Surname = Chinese name, Company, Email, Phone, DOB, Sales-leads date, Remarks), bulk-edit, and export a Google-ready CSV with leads date in its own column.
- v3 - 17-Jun-26 — Added Cross-check accounts (import the four account exports; reconcile by mobile).
- v2 - 17-Jun-26 — SOP001 v3 identity; Contact archive seeded from the 2025 workbook (3,124 de-duplicated contacts).
- v1 - 14-Jun-26 — Category-driven contact-line generator.
Line format: [Ref] [Name (HON)] - [(Type) Short / Org / Role] - [Remarks] - [Mobile] ([Date]). Empty pieces skipped. Example: G.0188 Penny Sunshine (MS) - (SB) HAPPYPANDA - VIP client - 012-345 6789 (01/04/2026)