Send another email - additional function requested to a previous solution
This relates to solution provided here:
https://www.experts-exchange.com/questions/28159451/Part-10-to-Import-more-data-into-spreadsheet.html
In addition to what this function does already I also need it to do the following:
1. Send another email to: nmai@333333
2. In subject: USD MC card activation request for {Col C Col B)
3. In the body:
Hi Nalleli,
Please activate card number {Col T} for {Col C Col B}
PIC:99553333
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com
The email address and PIC number I will change in the code once received.
Thank you!
https://www.experts-exchange.com/questions/28159451/Part-10-to-Import-more-data-into-spreadsheet.html
In addition to what this function does already I also need it to do the following:
1. Send another email to: nmai@333333
2. In subject: USD MC card activation request for {Col C Col B)
3. In the body:
Hi Nalleli,
Please activate card number {Col T} for {Col C Col B}
PIC:99553333
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com
The email address and PIC number I will change in the code once received.
Thank you!
ASKER
ok, here it goes. Let me know if this is clear.
Just as the above referenced previous solution performs:
WHEN a card number beginning with 5116 is inserted in Col T of Applicant Status AND when I insert a value into Col Q (Approved - note: its value turns to a date when I put an x in that column) do the following:
1. Send another email this time to: nmai@333333
2. In subject:
USD MC card activation request for {Col C Col B)
3. In the body:
Hi Nalleli,
Please activate card number {Col T} for {Col C Col B}
PIC:99553333
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com
Just as the above referenced previous solution performs:
WHEN a card number beginning with 5116 is inserted in Col T of Applicant Status AND when I insert a value into Col Q (Approved - note: its value turns to a date when I put an x in that column) do the following:
1. Send another email this time to: nmai@333333
2. In subject:
USD MC card activation request for {Col C Col B)
3. In the body:
Hi Nalleli,
Please activate card number {Col T} for {Col C Col B}
PIC:99553333
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gowflow, I have implemented this code and will test it shortly. Thank you!
ASKER
Excellent! Works perfectly, gowflow. Thank you very much.
Excellent and welcome.
gowflow
gowflow
ASKER
Hi Gowflow,
I have another question if you are interested and available.
I have another question if you are interested and available.
yes pls go ahead was taken by other issues.
gowflow
gowflow
ASKER
Great! Here we go. I had it in the wings ready to post:
https://www.experts-exchange.com/questions/28309393/Send-email-based-on-values-in-certain-cells-Applicant-Status-Earthport-Number.html
https://www.experts-exchange.com/questions/28309393/Send-email-based-on-values-in-certain-cells-Applicant-Status-Earthport-Number.html
ASKER
hi gowflow, any chance to work on the latest I posted above?
why don't you answer them and see where it takes you ? there is not only gowflow on the ground !!! you need to appreciate the free ride you have been having for so long !!!
gowflow
gowflow
ASKER
Well, I would go with them gowflow, but it would mean starting from scratch with them and since you said to "pls go ahead" I took that as meaning you're available and willing. If not, then I'm sorry to have burdened you.
gowflow