asked on 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!
Microsoft ExcelOutlook
Last Comment
JaseSt
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
gowflow, I have implemented this code and will test it shortly. Thank you!
ok
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