vba - Making a Lead Assignment email from excel spreadsheet -


i have extremely limited vba knowledge. have excel spreadsheet of lead contacts. want set drop-down list sends email specific person chose , returns contact info in body of email. don't know how email auto-populate , right now, email pops has "true" in body contact info rather returning text value in cell. how , add code fix this?

sub dropdown7_change()      dim answer string      answer = msgbox("are sure want assign lead?", _         vbyesno, "send email")     '    above code informs user automated email sent      'code uses users answer either carryout generated email process or not save changes.     if answer = vbno cancel = true     if cancel = true exit sub      if answer = vbyes           'connects outlook , retrieves information needed create , send email.         set outlookapp = createobject("outlook.application")         set olobjects = outlookapp.getnamespace("mapi")         set newmsg = outlookapp.createitem(olmailitem)          'contains email address of person receiving email.         newmsg.subject = "lead assigned you" 'sets automated subject line email         newmsg.body = "hello," & vbnewline & _             "you have been assigned lead. please follow contact" & vbnewline & _             activecell.offset(0, 3).range("k5").select             activecell.offset(0, 6).range("k5").select             activecell.offset(0, 7).range("k5").select          'above code has body of automated email         newmsg.display     end if  end sub ' end of function

if trying values offset range("k5") , need use offset .value , range("k5").offset(0, 3).value , value 3 columns right of cell "k5".

the code below, add values 3 cells columns offset cell "k5" email body:

sub dropdown7_change()      dim answer string      answer = msgbox("are sure want assign lead?", _         vbyesno, "send email")     '    above code informs user automated email sent      'code uses users answer either carryout generated email process or not save changes.     if answer = vbno         exit sub     else         if answer = vbyes              'connects outlook , retrieves information needed create , send email.             set outlookapp = createobject("outlook.application")             set olobjects = outlookapp.getnamespace("mapi")             set newmsg = outlookapp.createitem(olmailitem)              'contains email address of person receiving email.             newmsg.subject = "lead assigned you" 'sets automated subject line email             newmsg.body = "hello," & vbnewline & _                 "you have been assigned lead. please follow contact" & vbnewline & _                 range("k5").offset(0, 3).value & vbnewline & _                 range("k5").offset(0, 6).value & vbnewline & _                 range("k5").offset(0, 7).value & vbnewline                                  'above code has body of automated email             newmsg.display         end if     end if  end sub

Comments

Post a Comment

Popular posts from this blog

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more