Search:

Type: Posts; User: brokovich

Search: Search took 0.03 seconds.

  1. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Hi there

    I used a second choose function for the selection of the email address. It's not the way I would have prefered to do it but it does work!

    thanks.

    B
  2. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Thanks for looking at this but I have now found a way to resolve the problem.

    B :)
  3. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    HI RobDog

    Did you have any joy with the example i sent?

    thanks

    B
  4. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Here is a zipped version of the spreadsheet with the macro in it. The PMS Renewal October sheet the macro refers to is just a blank spreadsheet used as a template.

    Hope this helps!
  5. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    I changed it to this but I am still getting an error! It is now saying there is an application-defined or object-defined error??



    EmailAddr = Application.VLookup(Sheets("Adviser...
  6. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Thanks. I have taken out the Error skip and it is erroring on this line:

    EmailAddr = Application.VLookup(Range(sname), Sheets("Adviser Names").Range("B4:F6"), 5, False)

    The problem is it is not...
  7. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Thanks Robdog,

    Code attached as it works so far. This runs right through to the email with the attachment, but just doesn't select the relevant email address:

    Sub SendActiveWorkbook()

    Dim...
  8. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Thanks RobDog

    I've now got it to the stage where it is running the macro and bringing up the email with the sheet attached, but not entering the email address. do you know how I can set the...
  9. Replies
    16
    Views
    1,043

    Re: Auto Send Mail from Excel

    Thanks RobDog,

    The problem I have is that the spreadsheet needs to be filtered for each individual, this selection copied into a tenmplate, and the template emailed to the individual. I tried...
  10. Replies
    16
    Views
    1,043

    Auto Send Mail from Excel

    Hi there

    I am in the process of writing a macro that splits data on a spreadsheet, copies it into a new sheet, and then emails the new sheet to the relevant person before deleting the data.

    I...
  11. Re: Open other outlook profile and export calendar

    Sorry for delayed response. Been away, but the problem is still here!

    The only info from the appointments I require is the Subject Field, Location, Start date and Time.

    Thanks.

    B
  12. Re: Open other outlook profile and export calendar

    Thanks Rob Dog.

    I did consider that option but I need to be able to distinguish between the owners of the appointments. Also, the individual people using the calendars should not really be able...
  13. Re: Open other outlook profile and export calendar

    Can no one help with this?

    B.
  14. Open other outlook profile and export calendar

    Hi all

    I have developed a new system which uses information from a number of different people's outlook calendars. At the moment I am having to go into each profile and manually export their...
  15. Replies
    1
    Views
    566

    Select next row down

    Hi There

    I have a spreadsheet with approx 2300 rows on it. I need each row to be sorted in ascending order. Cell B in each row has the row heading, so i only want cells C to AM sorted.

    To save...
  16. Replies
    0
    Views
    1,218

    Export Outlook Calendar into Excel

    Hi all

    I am looking for some assistance with the export feature on outlook. I will soon have to export 65 calendars into excel files to link up with some excel code I have written.

    This...
  17. Replies
    6
    Views
    765

    Re: Select Range based on cell content

    I'm not sure which bit of it isn't working, but it is not pasting anything at all into Sheet 2 and i am just getting an error box with 400 written in it... :(
  18. Replies
    6
    Views
    765

    Re: Select Range based on cell content

    Thanks Opus

    That one doesn't seen to have worked. Someone else has suggested the following code:

    Sub filterADE()

    Sheets("Sheet1").Cells.autofilter 1, "ADE"...
  19. Replies
    6
    Views
    765

    Select Range based on cell content

    Hi there

    I am new to VBA and am trying to write some code to select a range of cells dependent on the content and copy and paste it into another worksheet.

    I have attached a sample file so that...
Results 1 to 19 of 19



Click Here to Expand Forum to Full Width