Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Macro sending e-mails

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a sheet with in column A my e-mail adresses.
    With my macro I can send an attachment to all these e-mail adresses,with one touch on a button.
    Now a must make an input of the range.
    Can somebody change my macro,so that automaticly the range is : A5 to the last row that is filled with an e-mail adresses.
    Piece of my macro:
    Dim olApp As Object, olMail As Object
    Dim rngeAddresses As Range, rngeCell As Range
    Set olApp = CreateObject
    "Outlook.Application")
    Set rngeAddresses = Application.InputBox(prompt:="Give the range of your e-mail adresses."
    For Each rngeCell In rngeAddresses.Cells

    Many thanks.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    do you want to be able to selet the range yourself or a set range?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-28 14:47, brettvba wrote:
    do you want to be able to selet the range yourself or a set range?
    I want that the macro automatckly set the range from A5 to the laste row of column A
    (I must have the possibility to add adresses without to change the range)

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this is what you want to select the range from a5 downwards

    Range("A5").Select
    Range(Selection, Selection.End(xlDown)).Select
    seletion = rngeaddresses

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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