vba - require loop for sending mail thru excel -

- 

sub mail_activesheet() ' works in excel 2000, excel 2002, excel 2003, excel 2007, excel 2010, outlook 2000, outlook 2002, outlook 2003, outlook 2007, outlook 2010     dim sourcewb workbook     dim destwb workbook     dim cell range     dim subj string     dim emailaddr string     dim cc string     dim bcc string     dim body string     dim attment string     dim outapp object     dim outmail object     dim x string      x = range("b2").select     until activecell = ""     company = activecell     activecell.offset(0, 1).range("a1").select     = activecell     activecell.offset(0, 2).range("a1").select     cemail = activecell     activecell.offset(1, -3).range("a1").select     emailaddr = range("l2")     cc = range("m2")     bcc = range("n2")     subj = range("o2")     attment = range("p2")     body = "dear all," & vblf _     & vblf _     & "request present ecs per below details & pl confirm after submission of data file.  " & vblf _     & vblf _     & "cecs handover date                 :" & range("i2") & vblf _     & vblf _     & "settlement date                       :" & range("j2") & vblf _     & vblf _     & "number of records                    :" & range("f2") & vblf _     & vblf _     & "total contra amount                 : " & range("g2") & vblf _     & vblf _     & "type of presentation                  : ecs debit" & vblf _     & vblf _     & "attachments                              : e-2 form/validation reports/ecs data file" & vblf _     & vblf _     & "thanks & regards" & vblf _     & vblf _     & "gobi l" & vblf _     & "ing vysya bank ltd | cecs | 100, eden park | 20 vittal mallya road | bangalore-560001 | ph :080-22532127 | "      application         .screenupdating = false         .enableevents = false     end      set sourcewb = activeworkbook     set destwb = activeworkbook      set outapp = createobject("outlook.application")      set outmail = outapp.createitem(0)          outmail             .to = emailaddr             .cc = cc             .bcc = bcc             .subject = subj             .body = body             .attachments.add (attment)             .display         end         loop      set outmail = nothing     set outapp = nothing      application         .screenupdating = true         .enableevents = true     end  end sub

please read , respect rules , take on link mehow provided.

as problem, have tried writing each recipient in column, looping through table , sending mail?

the table this:

                        b               c                 +---------------+---------------+---------------+--- ... 1 | r1@foo.bar    : r2@foo.bar    : r3@foo.bar    | 2 | cc1@bar.foo   : cc2@bar.foo   : cc3@bar.foo   | 3 | bcc1@far.boo  : bcc2@far.boo  :               |   +---------------+---------------+---------------+--- ... 4 | rr4@foo.bar   :               :               | 5 | cc4@bar.foo   : cc5@bar.foo   :               | 6 |               :               :               |   +---------------+---------------+---------------+--- ...

where in first line can put recipients, in second ccs , in third bccs. , in 4th line stats on again recipients. have loop through table , send mail.

little hint on side: can use step 3 increase iterator 3 (instead of 1) after iteration.


Comments

Post a Comment

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

-
this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
Read more

Does Firefox offer AppleScript support to get URL of windows? -

-
i trying write applescript that, among other things, gets url of every open webpage in firefox. in safari (and chrome), done simply: tell application "safari" return url of every tab in every window however, seems me firefox offers no real applescript support, such getting url of tab or window. when google terms "firefox" , "applescript" together, firefox bug requests asking applescript support restored, last updated in 2010 or 2011 (like this , this ). am right in thinking, then, firefox no longer offers proper applescript support? realize there semi-workarounds, such simulating key-commands in applescript, aren't practical purposes. to see of applescript commands firefox responds to, launch applescript editor, select menu file > open dictionary... , , choose firefox application. you'll find you're expecting: firefox doesn't offer useful applescript commands.
Read more

android - How to install packaged app on Firefox for mobile? -

-
how test-install packaged (zip) app on fennec? device: physical android phone or android emulator, don't care. install mozilla-apk-cli using npm: npm install -g mozilla-apk-cli use generate "debuggable" apk app either source directory or url mini-manifest: mozilla-apk-cli /path/to/source/dir/ arbitrary-name.apk mozilla-apk-cli http://example.com/path/to/mini/manifest.webapp arbitrary-name.apk (context-click > inspect element on "free" button in marketplace discover mini-manifest url app in marketplace.) install apk on android device: adb install -r arbitrary-name.apk launch app on device. notification area notification port remote debugger server listening on. forward port on desktop, f.e. if port 12345: adb forward tcp:12345 tcp:12345 go web developer > connect… in firefox on desktop , connect localhost @ forwarded port. commence debugging! notes: use nightly builds of fennec best experience. bug 929382 tracks ...
Read more