Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a cell value to an open outlook template
Hi all,
I have an existing code that does a whole bunch of other stuff, then goes to a specific cell and copies that cell's value and then opens an Outlook Template .oft. I would like to know if there is some code that will then paste that held value into the body of the open .oft document. I can just do a CTRL-V to paste it manually but would like this whole process to automate if possible. Sheets("Sheet1").Select Range("A2").Select Selection.Copy target = """G:\my file pathway\Check.oft""" Shell "cmd /cStart """" " & target I want to put the paste command here but am at a loss as to how to proceed. Any help would be really appreciated. I've only recently started using these discussion groups and I've learned more in a couple of weeks than in the past few years... Thanks!! Tracey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a cell value to an open outlook template
Hi Tracey,
Check out the section on email on Ron de Bruin's site at http://www.rondebruin.nl/sendmail.htm Alan -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy a cell value to an open outlook template
Thks Alan, but unfortunately I cannot get to Ron's site as I have limited
internet access at work. I don't really want to have go home and pick sections of code out and then wait to apply them the next morning and hope they work. I was hoping that somebody may be able to help me with the code directly. Guess I'll just have muddle to and fro between work and home. Tracey "Alan McQuaid via OfficeKB.com" wrote: Hi Tracey, Check out the section on email on Ron de Bruin's site at http://www.rondebruin.nl/sendmail.htm Alan -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link an email address in a cell to a MS Outlook template | Excel Discussion (Misc queries) | |||
Macro to Open another template and use the Cell in the new sheet | Excel Discussion (Misc queries) | |||
How to setup Excel Template to open in Outlook 2003 in body | Setting up and Configuration of Excel | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Open a template, copy 3 worksheets w ranges and save as workbook | Excel Programming |