vba - Targeting an open outlook email for population (Outlook 2010) -

-

i've been trying improve "quality of life" follow-up email process in office userform+vba snippet, , i've hit roadblock in while i've been able create brand new email , format stuff .body, .attachments.add, .to, etc., haven't been able figure out how reply already-existing email, necessary part of follow-up process.

i saw this page gave solution c#/vb.net, , in using object browser found "application.activeexplorer" exists in vba well. i'm working with:

private sub btnsubmit_click() dim msg string dim objmsg outlook.mailitem  set followup = objmsg.activeinspector.currentitem followup  ' compose message msg = "good morning," & "<br />" & "<br />" msg = msg & "this follow-up request following outstanding subjectivities: " & "<br />" & "<br />"  = 0 listbox1.listcount - 1     if listbox1.selected(i)     counter = counter + 1 msg = msg & listbox1.list(i) & "<br />"  else: if counter = 0 msg = msg & “nothing” end if next  msg = msg & "<br />" & "if these not submitted within 3 days, notice of cancellation sent." & _ "please let know if have questions or concerns." & "<br />" & "<br />"      .reply     .htmlbody = msg     ' .attachments.add (" ")     unload subjectivitiesselection     .display end  end sub

the end goal populate response message user can append appropriate user signature , send off, nothing fancy or automated makes life little easier , working little faster. i've got other things address in project (example: hitting ok without selecting of predetermined factors probably still build email regardless) go on biggest obstacle in path.

i apologize if isn't standards or if there's missing/unclear, i'm yet novice looking direction; been learning go object explorer, msdn, , plain old searching. i'll try clarify whatever can if there's ambiguous.

thanks time.

use mailitem.reply method - returns newly created mailitem object. code above not make sense - objmsg variable not initialized , mailitem object not have activeinspector property, application object does. might want @ application.activeexplorer.selection collection: contain selected items in folder. application.activeinspector messages opened in active inspector.


Comments

Post a Comment

Popular posts from this blog

ios - Memory not freeing up after popping viewcontroller using ARC -

-
hi project arc based, using uinavigationcontroller make transition between viewcontroller. using profiler analyse happening behind scene memory. noticed when push viewcontroller allocate memory components , when pop not freeing allocated memory. since using arc unable implement dealloc or release component. have analysed in detail , there no memory leak in project. i not using strong property push viewcontroller. here how pushing viewcontroller. viewcontroller *obj = [[viewcontroller alloc] init]; [self.navigationcontroller pushviewcontroller:obj animated:no]; any clue whats going on? should free memory have consumed. please advise your description indicates have retain cycle, leads objects not being deallocated. typical source of retain cycles properties assigned loading nib files (usually declared iboutlet ). two strategies break them , release objects: declare property weak : @property (nonatomic, weak) iboutlet uilabel *statuslabel; set property nil in...
Read more

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more