Excel - Outlook macro

  farrow 14:19 18 Jul 05

Anyone assist please
I am trying to write a Macro in Excel, assign it to a button which, when clicked on will send the excel spreadsheet to an e-mail address.
I can get the macro to open outlook but will not either
1. paste in an e-mail address or
2. look up an address
While the cursor is flashing in the "To" box in Outlook the macro seems to freeze at this point.

Do Excel Macros not work with other programmes or is there a anti-macro security feature in Outlook

Anyone have any ideas?


  VoG II 14:34 18 Jul 05

In the Visual Basic Editor, Tools | References and tick Microsoft Outlook X.X Library (X.X being your version of Outlook).

  farrow 17:19 18 Jul 05

Thanks for trying but it didn't seem to have any effect.
I wrote a macro using Macro Express and that worked perfectly. Unfortunately I can't use that as not all users of the Excel spreadsheet will have access to Macro Express. In Macro Express I had to build in time delays to allow for screen changes. Is that likely to be the problem with excel macros?

  VoG II 17:38 18 Jul 05

You could try a delay - the following will pause for 2 seconds:

Application.Wait (Now + TimeValue("0:00:02"))

  farrow 19:08 18 Jul 05


Thanks I will give that a go


  Access genu 21:01 18 Jul 05

This thread is now locked and can not be replied to.

Microsoft Surface Studio PC release date, pricing, design, features and spec: Microsoft showcases…

1995-2015: How technology has changed the world in 20 years

This amazing app turns your iPad Pro into a Cintiq

Apple Q4 2016 financial results | Apple earnings report: iPhone, iPad and Mac sales down, profits d6…