Part 7 to: Import more data into spreadsheet
This is a continuation from: https://www.experts-exchange.com/questions/28156423/Part-6-to-Import-more-data-into-spreadsheet.html
Gowflow, if the below is too much for one question, let me know and I'll break it up.
When I put a value in Col N (Funds Rcvd) AND there is already a value in Col K (USD MC) THEN do the following:
1. Open up an email and address it to: nmai@banking.bz, with a bcc going to: david@offshorelawcenter.co
2. Subject: New Mastercard Application for (here insert first and last name from Col B and C)
3. Body (without quotes):
"Hi Nalleli,
Attached are the documents and load request for (here insert first and last name from Col B and C)
Please have his card shipped to address indicated on spreadsheet.
PIC:99554Freedom
Please let me know you received this email.
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com"
4. Attach the files inserted into Applicant Status from all cells (Col E - H), even if it has as many as 5 or 6 (or more) different files on two (or more) different rows
That's it for now. This function will do a bit more later, once this one works.
Thank you!
Gowflow, if the below is too much for one question, let me know and I'll break it up.
When I put a value in Col N (Funds Rcvd) AND there is already a value in Col K (USD MC) THEN do the following:
1. Open up an email and address it to: nmai@banking.bz, with a bcc going to: david@offshorelawcenter.co
2. Subject: New Mastercard Application for (here insert first and last name from Col B and C)
3. Body (without quotes):
"Hi Nalleli,
Attached are the documents and load request for (here insert first and last name from Col B and C)
Please have his card shipped to address indicated on spreadsheet.
PIC:99554Freedom
Please let me know you received this email.
Thank you.
Michael
Sovereign Gold Card Support
www.sovereigngoldcard.com"
4. Attach the files inserted into Applicant Status from all cells (Col E - H), even if it has as many as 5 or 6 (or more) different files on two (or more) different rows
That's it for now. This function will do a bit more later, once this one works.
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"In other words, just putting a value in K starts the macro. "
I meant: In other words, just putting a value in N starts the macro.
I meant: In other words, just putting a value in N starts the macro.
ok sorry my mistake
replace these 2 lines in Workbbok_Change event of sheet 1
by these 2 lines
gowflow
replace these 2 lines in Workbbok_Change event of sheet 1
If Not Intersect(Target, Columns("N")) Is Nothing And _
Not Range("K" & Target.Row) Is Nothing Thenby these 2 lines
If Range("N" & Target.Row) <> "" And _
Range("K" & Target.Row) <> "" Thengowflow
ASKER
Perfect!
Now need to do something else, if you're open.
Now need to do something else, if you're open.
Shoot
ASKER
here you go:
https://www.experts-exchange.com/questions/28157691/Part-8-to-Import-more-data-into-spreadsheet.html
Thank you very much!!
https://www.experts-exchange.com/questions/28157691/Part-8-to-Import-more-data-into-spreadsheet.html
Thank you very much!!
ASKER
In other words, just putting a value in K starts the macro.
I need to have a value in Col K before it kicks off because in another addition to this code (future question) the email message and recipient will be different if there is a value in Col J and a value in K
Also, deleting a value in N pops up the email macro.