+ Reply to Thread
Results 1 to 9 of 9

Loop extention in mail macro

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Loop extention in mail macro

    Hello Friends,

    I need some help to add some variables in loop of below code. Location is mentioned in code.

    This is picked from http://www.rondebruin.nl/win/s1/outlook/amail6.htm

    Please Login or Register  to view this content.
    Thanks
    Liz
    Last edited by Liz_Biz; 05-07-2014 at 10:54 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Loop extention in mail macro

    cell.offset(0,cols)
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Loop extention in mail macro

    Hi nathansav,

    Thank you so much for looking into this!!

    Where I need to incert this? Could you help to get changes please?

    Thanks,
    Liz

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Loop extention in mail macro

    .bcc = cell.offset(0,1) will get the column one across to the right.

  5. #5
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Loop extention in mail macro

    No Luck.

    This is no working. I am using below code.
    Please Login or Register  to view this content.
    Thanks,
    Liz

  6. #6
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Loop extention in mail macro

    cell.offset(y,x).value your cc is the same as your to they way above, is this correct?

  7. #7
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Loop extention in mail macro

    nope. Cc is another column.

  8. #8
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Loop extention in mail macro

    well you need to change the offset from (0,0) then. Offset is move down y and move across x, so you are not moving.

    can you attach a sample, make it easier.

  9. #9
    Registered User
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Loop extention in mail macro

    Its done!! Thank you so much for great and so quick help.

    Liz..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extention
    By Razahsn in forum Excel General
    Replies: 1
    Last Post: 03-29-2014, 06:04 AM
  2. E-mail drafer macro leaves the body of the mail blank.
    By Gabor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2014, 05:00 PM
  3. Macro does not loop through all mail merge letters correctly
    By Bpd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2014, 01:39 PM
  4. [SOLVED] Use a Macro or VBA to utilize a command to e-mail selected cells to predetermined e-mail
    By jstn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2013, 10:39 AM
  5. Replies: 1
    Last Post: 12-28-2012, 03:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1