View Single Post
  #9  
Old January 2nd 09, 03:46 PM posted to microsoft.public.outlook.program_vba
wpiet
external usenet poster
 
Posts: 19
Default Can I disable Outlook warning from Excel macro "Send" method

Jimmy, did you just make a change to your site? I followed the link & was
reading the article but when I looked around the site and tried to go back to
the article, I got the "Something's wrong here" page.
I am able to access the main blog page, so I did a search on "export," got
six results but if I click on any of the result links, I get the same
"Something's wrong here" page. I noticed that the link you provided includes
"2008/08" in the URL but it redirects & drops the "2008." Thought that might
be relevant.
--
Will


"JP" wrote:

I have some sample code here that shows two different versions of the
same code for Excel and Outlook.

http://www.codeforexcelandoutlook.co...asks-to-excel/

It's basically what you and Ken stated -- just declare an object
reference to the Excel.Application Object, and you can port your Excel
code over to the Outlook VBIDE with minimal changes.

HTH

On Dec 31 2008, 10:43 am, wpiet
wrote:
My problem is that I don't have a clue what's possible from either
application, since I've never programmed for either one (or done any other
VBA coding).
As it is, the Excel workbook contains 5 worksheets & the macro does numerous
things, involving all of these sheets. The end result of the macro, before
the For Each . . . Next loop that accesses Outlook & sends the e-mails, is a
2-column worksheet, one column with e-mail addresses, the other with the
corresponding messages.
Are you saying that, from an Outlook macro, I can open the Excel workbook,
select that worksheet & loop through the rows, creating an e-mail for each
one?
Can I, in fact, do all the processing of the Excel workbook from the Outlook
macro, using CreateObject("Excel.Application") as the starting point, opening
the workbook & performing all the steps that are currently contained in the
Excel macro?
If so, I'm guessing it would mostly require changing the qualifiers on most
statements???

Thanks,
Will


Ads