Right now i'm using this formula to automatically open email app with email address and subject autofilled.
=HYPERLINK("mailto:"&F415&"?subject=Receipt "&A415&"&";"Email")
I would like to use the same formula to open Word app.
How could i do it?
I use Mac
See if this works for you.
Formula:
Please Login or Register to view this content.
9-26-2015 8-26-25 AM.jpg
For me the warning window keeps popping up , not sure how to stop that from happening
9-26-2015 8-31-22 AM.jpg
Last edited by davesexcel; 09-26-2015 at 10:33 AM.
Thank you!
It doesn't work:
"This formula you typed contains an error"
I think you need ";" not "," in your country
Almost there!
It's opening word but now i need it to display on Word the content of this cells: D413:F413.
This is the formula i have now:
=HYPERLINK("/Users/LuisAir/Desktop/Envelope.docx";"Print")
How can i add info displayed on D413:F413 to the word file automatically when it opens?
Formula:Please Login or Register to view this content.
Insert a bookmark in word 1st
InsertBookmark.jpgsave book mark.jpg
Add that bookmark name to your formula
formulaBookmark.jpg
YouTube Example
Last edited by davesexcel; 09-27-2015 at 11:54 AM.
Did not work out for me.
The f before the formula on N4 it's just to be able to save it otherwise i couldn't.
Please check attachments:
PrintWord.xlsxEnvelope.docx
try,
Formula:Please Login or Register to view this content.
Doesn't work!
Error.jpg
really, refer back to post #4
Hi.
Yes, i also tried that but still doesn't display the content of D4:E4.
Just opens Word file without any data.
Any clue?
Thank's for help man!
It could be your file address,
Here it is working for me
Hyperlink to word
For me it does the same but i guess you didn't get my main goal.
It's not only to open that word file, i need it to open the word file with the data on D4:E4 "David Melt" where it's now "MyBookmark".
Got it?
I believe I know what you are talking about
Formula:Please Login or Register to view this content.
If you have the word "MyBookmark" in H4
Still it doesn't work :/
Also tried with ; no error but still no data on word file!
Error.jpg
What do you mean no "data in word file?"
okay I think I get it.
Like the email formula, it adds the to: and subject: data.
You want the same to happen with the hyperlink to word formula and add some data with the formula.
I don't think a regular formula can do that, I suppose a UDF can be written for that
Ok, i will explain you the main porpouse:
N4 will be like a "button" so when i press it word will open that "Envelope" file with the data displayed on D4 and E4.
So i don't need only word to open, i need it to open but automatically filled with data within the cells D4 and E4.
That would be the costumer address so i would save time copy/pasting.
That was a pretty quick reply.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks