InsertFile
in [Word VBA]
|
Prev: Is there code to toggle "show column headers and row headers"
Next: Are Word2007 macros different from Word2003 macros ?
From: JayM on 29 Mar 2010 06:05 I currently have a macro which inserts a selected file from a directory. Sub GeneralUsertextClauses() With Dialogs(wdDialogInsertFile) .name = varUSERTEXT .Show End With End Sub How can I ensure that the selected file isn't an attachment when used with Outlook? JayM
From: JayM on 29 Mar 2010 06:17 Just needed to add this is a macro that I use in Word as well. So needs to work as well in both. Thanks JayM "JayM" wrote: > I currently have a macro which inserts a selected file from a directory. > > Sub GeneralUsertextClauses() > With Dialogs(wdDialogInsertFile) > .name = varUSERTEXT > .Show > End With > End Sub > > How can I ensure that the selected file isn't an attachment when used with > Outlook? > > JayM
From: Graham Mayor on 29 Mar 2010 06:49 Aside from the fact that varUSERTEXT is an undefined variable, what is the relevance of Outlook here? The macro simply displays the InsertFile dialog (or rather it would if varUSERTEXT actually referred to something). -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "JayM" <JayM(a)discussions.microsoft.com> wrote in message news:AD1E2E82-17B9-434F-ADD6-8FB5FC9CDBC7(a)microsoft.com... >I currently have a macro which inserts a selected file from a directory. > > Sub GeneralUsertextClauses() > With Dialogs(wdDialogInsertFile) > .name = varUSERTEXT > .Show > End With > End Sub > > How can I ensure that the selected file isn't an attachment when used with > Outlook? > > JayM
From: JayM on 29 Mar 2010 07:57 Sorry for not providing the full information varusertext is referenced as follows: Global Const varUSERTEXT As String = "w:\zzword97\usertext\" The relevance of Outlook is that these files could be inserted into word documents (for letters) or into emails if you are sending a email to a Client. The files could be standard paragraphs or addresses etc JayM "Graham Mayor" wrote: > Aside from the fact that varUSERTEXT is an undefined variable, what is the > relevance of Outlook here? The macro simply displays the InsertFile dialog > (or rather it would if varUSERTEXT actually referred to something). > > -- > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Graham Mayor - Word MVP > > My web site www.gmayor.com > Word MVP web site http://word.mvps.org > <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > > > "JayM" <JayM(a)discussions.microsoft.com> wrote in message > news:AD1E2E82-17B9-434F-ADD6-8FB5FC9CDBC7(a)microsoft.com... > >I currently have a macro which inserts a selected file from a directory. > > > > Sub GeneralUsertextClauses() > > With Dialogs(wdDialogInsertFile) > > .name = varUSERTEXT > > .Show > > End With > > End Sub > > > > How can I ensure that the selected file isn't an attachment when used with > > Outlook? > > > > JayM > > > . >
From: Graham Mayor on 29 Mar 2010 10:00
You are missing the point. If you are programming Outlook, then you should be asking your questions in an Outlook forum. They will want to know what version of Outlook and if prior to version 2007 whether you are using Word as e-mail editor or Outlook's own editor. With Word you might find Autotext or Autocorrect more convenient tools for inserting standard paragraphs - and surely your addresses would be inserted from Outlook Contacts? -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> "JayM" <JayM(a)discussions.microsoft.com> wrote in message news:C5F46138-71B9-4A72-BCD3-4B021CB00BD1(a)microsoft.com... > > Sorry for not providing the full information > > varusertext is referenced as follows: > Global Const varUSERTEXT As String = "w:\zzword97\usertext\" > > The relevance of Outlook is that these files could be inserted into word > documents (for letters) or into emails if you are sending a email to a > Client. > > The files could be standard paragraphs or addresses etc > > JayM > "Graham Mayor" wrote: > >> Aside from the fact that varUSERTEXT is an undefined variable, what is >> the >> relevance of Outlook here? The macro simply displays the InsertFile >> dialog >> (or rather it would if varUSERTEXT actually referred to something). >> >> -- >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> Graham Mayor - Word MVP >> >> My web site www.gmayor.com >> Word MVP web site http://word.mvps.org >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> >> >> >> "JayM" <JayM(a)discussions.microsoft.com> wrote in message >> news:AD1E2E82-17B9-434F-ADD6-8FB5FC9CDBC7(a)microsoft.com... >> >I currently have a macro which inserts a selected file from a directory. >> > >> > Sub GeneralUsertextClauses() >> > With Dialogs(wdDialogInsertFile) >> > .name = varUSERTEXT >> > .Show >> > End With >> > End Sub >> > >> > How can I ensure that the selected file isn't an attachment when used >> > with >> > Outlook? >> > >> > JayM >> >> >> . >> |