JaseSt
asked on
Opening an Outlook New Message Email from Excel
continuation from previous related question:
7. after doing point 6 from previous question, then open a new email message (outlook 2007)
8. add the attachment of this newly created Mastercard - sm spreadsheet to it
9. add to the body of the email message the below text:
Dear Nalleli,
Please see attached file for regular load request.
PIC:99554Freedom
Please let me know you received this email.
Thank you.
Michael
10. insert into the subject line this text:
MC - smTODAY'S DATE (example: MC-smSept10-11)
7. after doing point 6 from previous question, then open a new email message (outlook 2007)
8. add the attachment of this newly created Mastercard - sm spreadsheet to it
9. add to the body of the email message the below text:
Dear Nalleli,
Please see attached file for regular load request.
PIC:99554Freedom
Please let me know you received this email.
Thank you.
Michael
10. insert into the subject line this text:
MC - smTODAY'S DATE (example: MC-smSept10-11)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'll look it over, but before I do, the sender email address is: support@sovereigngoldcard. com
ok then pls replace this following Line in Sub SendEmail
1) goto VBA
2) doubleclick Module1 click on left icon to view 1 sub at a time
3) Display Sub SendEmail(fName As String)
4) Replace This Line (in the first couple lines of the Sub under 'Fill in Subject Details)
SendTo = ""
By this Line
SendTo = "support@sovereigngoldcard .com"
5) Save the workbook and close it
6) Start it again and try it out.
gowflow
1) goto VBA
2) doubleclick Module1 click on left icon to view 1 sub at a time
3) Display Sub SendEmail(fName As String)
4) Replace This Line (in the first couple lines of the Sub under 'Fill in Subject Details)
SendTo = ""
By this Line
SendTo = "support@sovereigngoldcard
5) Save the workbook and close it
6) Start it again and try it out.
gowflow
ASKER
Beautiful! Worked like a charm!!!
I ran it before I saw your last comment. I will insert that into the code and try it again tomorrow am with the send to address.
Great work, gowflow! Thank you.
I have a few other things for this MasterCard workbook - fairly simple I believe - and then have a few others for my Visa workbook if interested.
I ran it before I saw your last comment. I will insert that into the code and try it again tomorrow am with the send to address.
Great work, gowflow! Thank you.
I have a few other things for this MasterCard workbook - fairly simple I believe - and then have a few others for my Visa workbook if interested.
Shoot all the questions that you want. Pls post here any other issue you may need help with as cannot screen all questions beeing posted to find yours. I had similar issue with an other question where the guy said he would post a new question he never told me about it and I waited he cot it answered where it all started with my formula.
gowflow
gowflow
ASKER
Great! Here's the next one. You've done something very similar with going through Outlook and retrieving data for 'individual' sheets. This question is for emails coming in from our resellers: the MCR and HMF Account pages:
https://www.experts-exchange.com/questions/27308955/Obtaining-data-from-Outlook-Emails.html
https://www.experts-exchange.com/questions/27308955/Obtaining-data-from-Outlook-Emails.html
ASKER
Inserted the send to email address and it worked perfectly. Wow! Great work gowflow. Getting rid of the day after day repetitive actions certainly saves me a lot of time and reduced potential for human error.
Thanks again!
Thanks again!
Well that's what is 'good developpment' all about !! Am glad I am part of getting your daily work more organised and better handled.
gowflow
gowflow
You have not specified the sender email
gowflow