Will Macros Work in Windows 7?
in [Word VBA]
|
From: John Ciccone on 14 May 2010 12:23 Actually I was referring to what can be done programmatically using VBA macros in Word. With OE you can mail merge a document that creates an email message with sender, recipient, subject, etc. and up pops the email using something like: RetVal = Shell("C:\Program Files\Windows Mail\winmail.exe /eml:C:\Users\John\Desktop\" + IDNumName$ + ".eml", vbNormalFocus) It's been a few years, but I just remember not being able to do the same thing with Outlook. "Doug Robbins - Word MVP" wrote: > I believe that the only thing of significance that you can do in Outlook > Express/Windows Mail/Windows Live Mail that you cannot do in Outlook is use > it as a News Reader. > > With the demise of the Microsoft hosted NNTP newsgroups such as this on June > 1, that is no longer an issue. > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP, originally posted via msnews.microsoft.com > > "John Ciccone" <JohnCiccone(a)discussions.microsoft.com> wrote in message > news:2C5FFBF2-BFF1-43C4-87A2-646C9B8ED5AE(a)microsoft.com... > > Thanks for your time, Doug. > > > > It's been a while so I don't remember the details, but I didn't seem to be > > able to do the same things with Outlook as I can with Outlook Express and > > Windows Mail. Wish I could. > > > > Cheers. > > > > "Doug Robbins - Word MVP" wrote: > > > >> With Windows 7, you will need to download the free Windows Live Mail to > >> get > >> the equivalent to Outlook Express or Windows Mail. > >> > >> If you have a version of Office that includes Outlook, I would suggest > >> that > >> you set up your mail account in that and set it as the default mail > >> client. > >> > >> If you cannot do that, then you will need to download Windows Live Mail, > >> you > >> can do it from the following website > >> > >> http://www.microsoft.com/downloads/details.aspx?FamilyID=56883de5-2024-4631-806e-757693072a1c&displaylang=en > >> > >> To use the Send To option in Office applications with Windows Live Mail, > >> it > >> may be necessary to make the following changes to the Window Registry. > >> > >> Note: Just in case something goes wrong, you should first back up the > >> registry by following the steps in the following article: > >> > >> http://windows.microsoft.com/en-US/windows7/Back-up-the-registry > >> > >> Now, back to the original issue: > >> > >> 1. Click on Start > All Programs > Accessories > Run > Type regedit > >> > >> 2. Browse to HKEY_LOCAL_MACHINE > Software > Client > Click on Mail > >> > >> 3. Check what appears in the right pane. It should read as below: > >> > >> (Default) REG_SZ Windows Live Mail > >> > >> 4. If Windows Live Mail does not appear, right click on (Default) and > >> click > >> on Modify and in the Value Data box, type > >> Windows Live Mail > >> > >> Note: If you don't find the Mail item, right click on Client and Click > >> New > > >> Key and rename the key to: > >> > >> > >> Once the Mail key is created, right click on Mail > New > String Value. > >> Name > >> the value as: > >> > >> (Default) > >> > >> Right click on (Default) and Click Modify. In the Value Data box type > >> > >> Windows Live Mail > >> > >> > >> -- > >> Hope this helps. > >> > >> Please reply to the newsgroup unless you wish to avail yourself of my > >> services on a paid consulting basis. > >> > >> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com > >> > >> "John Ciccone" <JohnCiccone(a)discussions.microsoft.com> wrote in message > >> news:063D5AF5-1AA6-4BDB-843F-50D886989C20(a)microsoft.com... > >> > I have macros in Word (2007 and Word 97) that do a mail merge and > >> > create > >> > an > >> > email in Outlook Express and Windows Mail. > >> > > >> > Will these macros work in Windows 7? I understand that Windows Mail > >> > comes > >> > with that OS. > >> > > >> > Thanks. > >>
From: Doug Robbins - Word MVP on 14 May 2010 16:38 You can certainly use Outlook to send email messages created by the use of mail merge (and many other things as it has an object model that can be accessed via VBA), which is not the case with Outlook Express/Windows Mail/Windows Live Mail. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "John Ciccone" <JohnCiccone(a)discussions.microsoft.com> wrote in message news:00C500AB-79B1-4E6E-92AB-76C4EE787956(a)microsoft.com... > Actually I was referring to what can be done programmatically using VBA > macros in Word. > > With OE you can mail merge a document that creates an email message with > sender, recipient, subject, etc. and up pops the email using something > like: > > RetVal = Shell("C:\Program Files\Windows Mail\winmail.exe > /eml:C:\Users\John\Desktop\" + IDNumName$ + ".eml", vbNormalFocus) > > It's been a few years, but I just remember not being able to do the same > thing with Outlook. > > "Doug Robbins - Word MVP" wrote: > >> I believe that the only thing of significance that you can do in Outlook >> Express/Windows Mail/Windows Live Mail that you cannot do in Outlook is >> use >> it as a News Reader. >> >> With the demise of the Microsoft hosted NNTP newsgroups such as this on >> June >> 1, that is no longer an issue. >> >> -- >> Hope this helps. >> >> Please reply to the newsgroup unless you wish to avail yourself of my >> services on a paid consulting basis. >> >> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com >> >> "John Ciccone" <JohnCiccone(a)discussions.microsoft.com> wrote in message >> news:2C5FFBF2-BFF1-43C4-87A2-646C9B8ED5AE(a)microsoft.com... >> > Thanks for your time, Doug. >> > >> > It's been a while so I don't remember the details, but I didn't seem to >> > be >> > able to do the same things with Outlook as I can with Outlook Express >> > and >> > Windows Mail. Wish I could. >> > >> > Cheers. >> > >> > "Doug Robbins - Word MVP" wrote: >> > >> >> With Windows 7, you will need to download the free Windows Live Mail >> >> to >> >> get >> >> the equivalent to Outlook Express or Windows Mail. >> >> >> >> If you have a version of Office that includes Outlook, I would suggest >> >> that >> >> you set up your mail account in that and set it as the default mail >> >> client. >> >> >> >> If you cannot do that, then you will need to download Windows Live >> >> Mail, >> >> you >> >> can do it from the following website >> >> >> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=56883de5-2024-4631-806e-757693072a1c&displaylang=en >> >> >> >> To use the Send To option in Office applications with Windows Live >> >> Mail, >> >> it >> >> may be necessary to make the following changes to the Window Registry. >> >> >> >> Note: Just in case something goes wrong, you should first back up the >> >> registry by following the steps in the following article: >> >> >> >> http://windows.microsoft.com/en-US/windows7/Back-up-the-registry >> >> >> >> Now, back to the original issue: >> >> >> >> 1. Click on Start > All Programs > Accessories > Run > Type regedit >> >> >> >> 2. Browse to HKEY_LOCAL_MACHINE > Software > Client > Click on Mail >> >> >> >> 3. Check what appears in the right pane. It should read as below: >> >> >> >> (Default) REG_SZ Windows Live Mail >> >> >> >> 4. If Windows Live Mail does not appear, right click on (Default) and >> >> click >> >> on Modify and in the Value Data box, type >> >> Windows Live Mail >> >> >> >> Note: If you don't find the Mail item, right click on Client and Click >> >> New > >> >> Key and rename the key to: >> >> >> >> >> >> Once the Mail key is created, right click on Mail > New > String >> >> Value. >> >> Name >> >> the value as: >> >> >> >> (Default) >> >> >> >> Right click on (Default) and Click Modify. In the Value Data box type >> >> >> >> Windows Live Mail >> >> >> >> >> >> -- >> >> Hope this helps. >> >> >> >> Please reply to the newsgroup unless you wish to avail yourself of my >> >> services on a paid consulting basis. >> >> >> >> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com >> >> >> >> "John Ciccone" <JohnCiccone(a)discussions.microsoft.com> wrote in >> >> message >> >> news:063D5AF5-1AA6-4BDB-843F-50D886989C20(a)microsoft.com... >> >> > I have macros in Word (2007 and Word 97) that do a mail merge and >> >> > create >> >> > an >> >> > email in Outlook Express and Windows Mail. >> >> > >> >> > Will these macros work in Windows 7? I understand that Windows Mail >> >> > comes >> >> > with that OS. >> >> > >> >> > Thanks. >> >>
First
|
Prev
|
Pages: 1 2 Prev: Styles not applying correctly Next: Delete hilighted words (wdYellow) |