Hi Tim,
Received the below questions I’m hoping you can clarify:
1) that there may be some missing postal codes for Canada.
- Tim Thomas gave me some Calgary postal codes that are in premium areas
(T3E7M8, T0L0X0) for testing purposes and they are not in your Excel file
- V7V1J7 is in West Vancouver and is not in your file or Salesforce, but
is serviced by TheKey Canada
2) Canada at one point served Halifax, but there aren't any postal codes in
that area.
*Chad Everitt*
President- East Division & Canada
Mobile: 202.262.8318
[image: TheKey] <https://homecareassistance.com/>
---------- Forwarded message ---------
From: Ray Smale <ray.smale@thekey.com>
Date: Wed, Apr 17, 2024 at 7:11 AM
Subject: Fwd: Updated zip codes for SF
To: Chad Everitt <chad.everitt@thekey.com>
CC: Gabrielle Wolfe <gwolfe@thekey.com>, Phil Chanda <phil.chanda@thekey.com>,
Sardar Azimov <sardar.azimov@thekey.com>
Hi Chad,
The ladies have pointed out questions with what you provided for:
1. Canada
2. Recently closed offices
Pls see below and let us know.
Thanks,
Ray
---------- Forwarded message ---------
From: Gabrielle Wolfe <gwolfe@thekey.com>
Date: Tue, Apr 16, 2024 at 11:12 PM
Subject: Re: Updated zip codes for SF
To: Ray Smale <ray.smale@thekey.com>
CC: Phil Chanda <phil.chanda@thekey.com>, Sardar Azimov <
sardar.azimov@thekey.com>
As well, it looks like the Charleston and Columbia offices are closed and
we no longer are licensed there. This may have just happened though I only
saw an email about it this week with them asking to remove all zip codes
supported by Columbia and Charleston.
GW
Gabrielle Wolfe
* Head of Contact Center*
gwolfe@thekey.com <https://brand.thekey.com/esg/gwolfe@thekey.com>
+1-360-502-3020
TheKey.com <https://www.thekey.com/>
[image: TheKey] <https://homecareassistance.com/>
On Tue, Apr 16, 2024 at 8:52 PM Ray Smale <ray.smale@thekey.com> wrote:
> Thanks Phil.
> Let’s see if we can get clarity from the source (who I believe is Chad)
> and let’s get him to connect with Tim. We can’t decide this - garbage in
> garbage out as they say.
> If the source is Chad then let’s ask him to confirm his submission.
>
> On Tue, Apr 16, 2024 at 9:54 PM Phil Chanda <phil.chanda@thekey.com>
> wrote:
>
>> Hi Sardar & Ray,
>>
>> I took a look at your file and noticed a few things:
>>
>> 1) that there may be some missing postal codes for Canada.
>> - Tim Thomas gave me some Calgary postal codes that are in premium areas
>> (T3E7M8, T0L0X0) for testing purposes and they are not in your Excel file
>> - V7V1J7 is in West Vancouver and is not in your file or Salesforce, but
>> is serviced by TheKey Canada
>>
>> 2) Canada at one point served Halifax, but there aren't any postal codes
>> in that area.
>>
>> Can we discuss over email or on our Monday call?
>>
>> Thanks,
>> Phil
>>
>>
>>
>>
>>
>>
>>
>> ---------- Forwarded message ---------
>> From: Phil Chanda <phil.chanda@thekey.com>
>> Date: Mon, Apr 15, 2024 at 3:39 PM
>> Subject: Re: Updated zip codes for SF
>> To: Sardar Azimov <sardar.azimov@thekey.com>
>> Cc: Ray Smale <ray.smale@thekey.com>, Gabrielle Wolfe <gwolfe@thekey.com>
>>
>>
>> Hi Sardar,
>>
>> I will take a look at the file and will let you know if I have any
>> questions.
>>
>> CC'ing Gabrielle so that she is aware. Our Salesforce team will likely
>> need to reformat this for their upload.
>>
>> Thanks,
>> Phil
>>
>>
>>
>> On Mon, Apr 15, 2024 at 3:31 PM Sardar Azimov <sardar.azimov@thekey.com>
>> wrote:
>>
>>> Hi Phil,
>>>
>>> I hope you had a good weekend.
>>>
>>> I'm attaching the file with all the zip codes reviewed and appended with
>>> counties and states (plus other details from the zip code source files I
>>> used for appending; you can disregard those you don't need).
>>>
>>> I've added the comments from the divisions in column G for reference.
>>> Column H shows whether the data has changed.
>>>
>>> With Ray, we thought that one quick win for the website would be
>>> indicating the county instead of the name of each office.
>>>
>>> I'm happy to have a call and walk through the steps applied if you'd
>>> like. You might also have some questions related to the website's dynamic
>>> data display.
>>>
>>> Thank you,
>>>
>>> Sardar
>>>
>>>