Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create macro to write email address in email window
I am trying to get a link or button which will pop up an Outlook New Email
window with the current word document attached. At this stage i either have a hyperlink which opens the new email window with the addresses i want or a macro which opens a new email window and attaches the document.....but! I need these to come together? An email window with the address AND the document attached.....what can i do? TIA |
#2
|
|||
|
|||
Hi Cindy-
Its probably easiest to record a new macro to choose FileSend ToMail Recipient (as Attachment), select the recipient as one of the macro actions, then stop recording. You can use ToolsCustomize to add a button to a toolbar & assign the macro to it, or you can create the button as a part of the Record New Macro process from the first dialog box where you name your macro. HTH |:) "albycindy" wrote: I am trying to get a link or button which will pop up an Outlook New Email window with the current word document attached. At this stage i either have a hyperlink which opens the new email window with the addresses i want or a macro which opens a new email window and attaches the document.....but! I need these to come together? An email window with the address AND the document attached.....what can i do? TIA |
#3
|
|||
|
|||
I have no idea why, but that's not working. i thought id try to write a code
to do what im after and so far have. Private Sub CommandButton1_Click() wdNewEmailMessage.AutoAttach MailAddressFieldName = " EmailSubject = "Request for Claim - Account 610622F" End Sub Anywhere near? "CyberTaz" wrote: Hi Cindy- Its probably easiest to record a new macro to choose FileSend ToMail Recipient (as Attachment), select the recipient as one of the macro actions, then stop recording. You can use ToolsCustomize to add a button to a toolbar & assign the macro to it, or you can create the button as a part of the Record New Macro process from the first dialog box where you name your macro. HTH |:) "albycindy" wrote: I am trying to get a link or button which will pop up an Outlook New Email window with the current word document attached. At this stage i either have a hyperlink which opens the new email window with the addresses i want or a macro which opens a new email window and attaches the document.....but! I need these to come together? An email window with the address AND the document attached.....what can i do? TIA |
#4
|
|||
|
|||
Hello Again-
I'm not a coder, so I can't give you a solution. I believe I do see where the flaw in my earlier suggestion may be, however. Once you choose the ...As attachment command, Word 'assumes the identity' of Outlook, so nothing you do in the message window gets recorded because those actions are not actually taking place in Word. I believe you need VBA statements that pass the commands/info to Outlook, so recording ain't gonna do it. perhaps this will help point you in the right direction. Good Luck |:) "albycindy" wrote: I have no idea why, but that's not working. i thought id try to write a code to do what im after and so far have. Private Sub CommandButton1_Click() wdNewEmailMessage.AutoAttach MailAddressFieldName = " EmailSubject = "Request for Claim - Account 610622F" End Sub Anywhere near? "CyberTaz" wrote: Hi Cindy- Its probably easiest to record a new macro to choose FileSend ToMail Recipient (as Attachment), select the recipient as one of the macro actions, then stop recording. You can use ToolsCustomize to add a button to a toolbar & assign the macro to it, or you can create the button as a part of the Record New Macro process from the first dialog box where you name your macro. HTH |:) "albycindy" wrote: I am trying to get a link or button which will pop up an Outlook New Email window with the current word document attached. At this stage i either have a hyperlink which opens the new email window with the addresses i want or a macro which opens a new email window and attaches the document.....but! I need these to come together? An email window with the address AND the document attached.....what can i do? TIA |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Mail Merge to Email to Multiple Recipients in the Same Mes | Mailmerge | |||
How do I write a macro to find, select, and then delete a Section. | Microsoft Word Help | |||
When i open a new document my email address is inserted into the . | Microsoft Word Help | |||
fax numbers show in address when I email | Mailmerge | |||
how do i create a mail merge for email using excel as a data sourc | Mailmerge |