![]() ![]() the mailmerge to be run from a button in Excel and.I see that you've added two new requirements, viz: The spaces represented in the field constructions are all required. you can't type or copy & paste them from this message, either). '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. Nor is it practical to add them via any of the standard Word dialogues. You don't need VBA for this with the question as originally posted - simply use a SKIPIF field coded as: ') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9) you can't simply type them or copy & paste them from this message. Later on I want to be able to automatically save it to pdf as well with the same button but first I want this to work. It will then check where the ID is placed(which row in A column) in the excel sheet which is A3 for this example and will pull the rest of this person's information into the word template I have created beforehand.(ID, Name, Last Name, Country and Date). When a user runs the code it will pop up an input box and it will ask him to type an ID, I want to have a button which will ask for an ID input and will then take all the other info of that person and place it in the word template in the correct place. ![]() I have data like this in my excel sheet : I am trying to create a code which will be executed with a click of a button in the excel sheet and will ask me for an input of a cell value in excel which will then take all the data from that cell's row and insert it accordingly in the word template where the mail merge tags are. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |