Re: Email Macro Late Binding

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Ron
Thanks, appriciate that you'll look into it.
Kind regards
Jan

"Ron de Bruin" skrev:

> Hi Jan
>
> I will test it this evening for you but I can't remember seeing this problem
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Jan Holmstrom" <JanHolmstrom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:C502EBD8-AD69-4290-A50E-227034AEE8F3@xxxxxxxxxxxxxxxx
> > When using the "late binding" method (Ron de Bruin), the Outlook warning is
> > not shown on top of the screen. But it is hidden behind the Active Sheet.
> > This block for the program and I have to use CTRL+ALT+DEL to stop and shut
> > down the excelfile.
> >
> > It works when I use ".Display" instead of ".Send". But I would like the
> > macro to run the whole sequense with no manuel interferrence.
> >
> > I do not have the problem when I use the "Early Binding" method. But I need
> > to use Late Binding as I do not know the excelversion, the receivers of my
> > program have.
> >
> > This is the contens of the macro:
> >
> > Sub saveprintsend()
> >
> > ' saveprintsend Macro
> >
> > ' Macro recorded 02-06-2005 by Holmstrom
> >
> > ActiveWorkbook.Save
> > ActiveWorkbook.Printout
> > Dim OutApp As Object
> > Dim OutMail As Object
> > Set OutApp = CreateObject("Outlook.Application")
> > Set OutMail = OutApp.CreateItem(0)
> > With OutMail
> > .To = "holmstrom@xxxxxxxxxxxxxxx"
> > .CC = ""
> > .BCC = ""
> > .Subject = "ENERGY USE REPORT"
> > .Body = "ATTACHED FIND REPORT FROM DOWNMENTIONED"
> > .Attachments.Add ActiveWorkbook.FullName
> > .Send
> > End With
> > Set OutMail = Nothing
> > Set OutApp = Nothing
> > Application.DisplayAlerts = False
> > Application.Quit
> > End Sub
> >
> > If you can help me on this - I will be extremely joyfull.
> >
> > Thanks in advance and best wishes
> >
> >
>
>
>
.

Relevant Pages

  • Re: Copy from recordset errors in ADO
    ... with kind regards ... "Ron de Bruin" wrote: ... There are 35 funds and the number of rows varies per fund. ...
    (microsoft.public.excel.programming)
  • Re: update links
    ... with kind regards ... "Ron de Bruin" wrote: ... If i run the code as below i still have to select each link in the msgbox ...
    (microsoft.public.excel.programming)
  • Re: Basic ADO medthod - working with recordset, plz help.
    ... Ron de Bruin Wrote: ... But with closed book, I not only want to get it data but also edit or ... Kind Regards ...
    (microsoft.public.excel.programming)
  • Re: sending e-mail notice after any updating in spreadsheets
    ... > With OutMail ... > Now you know why I like mailing with CDO code. ... > Regards Ron de Bruin ...
    (microsoft.public.excel.programming)
  • Re: Renaming Files
    ... "Ron de Bruin" wrote: ... Dim FileNameXls As Variant ... Dim ShName As String, PathStr As String ...
    (microsoft.public.excel.programming)