Link to home
Create AccountLog in
Avatar of JaseSt
JaseStFlag for United States of America

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!
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

You have so many send email that I need to know this one is related to what situation ? when what cells is modified and what is already sent ?? which need to be added the above ?
gowflow
Avatar of 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
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of JaseSt

ASKER

gowflow, I have implemented this code and will test it shortly. Thank you!
Avatar of JaseSt

ASKER

Excellent! Works perfectly, gowflow. Thank you very much.
Excellent and welcome.
gowflow
Avatar of JaseSt

ASKER

Hi Gowflow,

I have another question if you are interested and available.
yes pls go ahead was taken by other issues.
gowflow
Avatar of JaseSt

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
Avatar of JaseSt

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.