How to get Excel input box string into single Word eMailMerge doc

[brucemc777]

Hello!

I am using Excel with Word for an eMailMerge.

In one implementation which only goes to one specific person at a time, I need to allow the user to input a short string that he does not want to make into a field (ergo, input...).

We experimented with Mr. de Bruin's methods, but he wanted to have more flexibility over changing his letter and wanted that which Word provides, so we went to the hybrid Excel-Word solution as we were already employing it for the subdivision "blast".

The eMailMerge document itself is a standard docx letter with fields defined for the merge and called from code as others have guided me (at considerable length) to develop on this board.

Can this be done relatively simply, or should I just say it needs to become a field in the table from which the other information is extracted?

MUCH appreciate your wisdom!

[macropod]

That's a tall ask when we don't know what code you're using or where this mysterious output is supposed to go...

Getting the user input is as simple as using an InputBox. The trick is in doing something with it and, for that, clear rules are needed.

[brucemc777]

But cytop and you wrote most of it ...

Parameters: vrtSelectedItem is the full path and filename of the user selected document from a calling procedure.
strSubject is a user input of the subject line.

The string I want to plant into the Word document could also be sent as a parameter to the following code from the calling procedure.

Please Login or Register  to view this content.

I have a faint memory of having done this before by using a bookmark in the Word document, but I do not know if the method is applicable, nor if it is the most direct route, but I did know that you folks would be able to advise me on the "Best Practices" course of action (I am avoiding saying "the best course of action" as I historically have seen that result in an esoteric debate of the term "best" relative to the universe and all within).

Thank-you!

[macropod]

But cytop and you wrote most of it

That's all very well, but the mere fact we've given you some code and you've implemented it in a way we hadn't seen means it would be unwise to assume anything...

After:
With wdDoc
you could insert:
.Bookmarks("MyBookmark").Range.InsertBefore InputBox("What is your supplementary text?")
where 'MyBookmark' is the name of a bookmark in your mailmerge main document.

[brucemc777]

Many Thanks!