Search:

Type: Posts; User: Macropod; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.33 seconds.

  1. Re: How to Open Word file (already having Mailmerged details) from excel

    Well, if you'd left those parts of the code alone, you wouldn't have any duplicates. What you've failed to understand is that the mailmerge main document is used to produce the output document. As...
  2. Re: How to Open Word file (already having Mailmerged details) from excel

    You really should have left the code alone... instead of commenting-out and deleting lines you don't understand.
  3. Re: How to Open Word file (already having Mailmerged details) from excel

    Do NOT do that!!! You'll inevitably lose the merged data if you do.
  4. Re: How to Open Word file (already having Mailmerged details) from excel

    You end up with two open documents because you've commented-out the code that closes the mailmerge main document...
  5. Re: How to Open Word file (already having Mailmerged details) from excel

    It 'worked' because you changed the 'WHERE' part of the query string you used between posts 17, 19 and 22, from:
    WHERE `Status` = `Approved`
    and:
    WHERE `Status` = Approved
    to:
    WHERE `Status` =...
  6. Re: How to Open Word file (already having Mailmerged details) from excel

    If by that you mean you need to create a separate file for each record, see: https://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
  7. Re: How to Open Word file (already having Mailmerged details) from excel

    What was the exact QueryString returned by the macro?
  8. Re: How to Open Word file (already having Mailmerged details) from excel

    The string:
    `'Guest_Speakers$'`
    should probably be:
    `Guest_Speakers$`
  9. Re: How to Open Word file (already having Mailmerged details) from excel

    AFAIK, mailmerge doesn't work with data files in sharepoint folders.
  10. Re: How to Open Word file (already having Mailmerged details) from excel

    In Word, connect the document to the datasource so it becomes a true mailmerge mail document, then apply the required filter. Having done that, run the following macro and check the output against...
  11. Replies
    15
    Views
    273

    Re: Adding st, nd, rd, th to ranked values

    The following two sub-routines, placed in the relevant worksheet’s code module, together with the third sub-routine and the accompanying function in a standard module, will automatically apply...
  12. Re: How to Open Word file (already having Mailmerged details) from excel

    Fairly obviously, I would have thought, you need to change "\\Sachin\c\CERTIFICATE\Loan from Bank.doc" to match your own situation. You may also need to change the sheet name (i.e. 'Sheet1') in...
  13. Re: How to convert formatted text to html in Excel

    I can't see why you'd get such an error message unless you have a faulty Excel installation or you've made an error in replicating the code. I get no such error when copying/pasting it from here into...
  14. Replies
    1
    Views
    765

    Re: Mail Merge - Blank Spaces

    How is the output supposed to change when 'Life Insurance', for example, is empty, compared to when the same field contains data? Your post so far doesn't give any indication of this. Note also that...
  15. Re: How to convert formatted text to html in Excel

    Simply open the VBA Editor (e.g. Alt-F11), then copy the code from here and paste it into the VBA Editor and make the code edits that have been suggested in post 6. You can then close the VBA Editor...
  16. Replies
    1
    Views
    957

    Re: MS Word Bar Codes

    If you're seeing something like:
    {DisplayBarcode “490123456789” EAN13 \t}
    all that means is that you have the field code display toggles on. Pressing Alt-F9 toggles the field code display on/off.
  17. Re: How long does it take a moderator to approve a post

    Depends on whether & when there are any moderators on-line.
  18. Re: Macro to use mail merge with word and then save each printout as a pdf

    See Send Mailmerge Output to Individual Files and Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips and Tricks thread at:...
  19. Replies
    10
    Views
    368

    Re: Luhn check digit formula

    I have to wonder what parameters you used to search here for previous threads on this. A simple search for Luhn returns 24 threads. See, for example:...
  20. Replies
    4
    Views
    403

    Re: Importing Excel Range data to Word doc

    Provided the first argument is kept 'False' , either of the second two of the .PasteExcelTable arguments will allow you to edit the content in Word - as will .PasteSpecial DataType:=wdPasteOLEObject.
  21. Re: VBA - Delete row based on cell above (date) and cells left (number)

    This thread is a duplicate of: https://www.mrexcel.com/forum/excel-questions/1101762-vba-delete-row-based-cell-above-date-cells-left-number.html
    Kindly read Mr Excel's policy in Rule 12 against...
  22. Thread: PDF To Excel

    by Macropod
    Replies
    1
    Views
    232

    Re: PDF To Excel

    As per Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html, kindly provide a link to your cross-post at Excel Forum. And, as per...
  23. Replies
    3
    Views
    229

    Re: Mail Merge/ VBA

    How it's done with a mailmerge depends entirely on how your workbook is configured. Numerous approaches are possible.

    For example, you can use Word's Catalogue/Directory Mailmerge facility (the...
  24. Re: Passing variables from Child (Word) to Parent (Excel)

    Which is what the code in post # 13 should do. To make it stand out more though, the username & time are not output - but it's easy to add that back in if you want.
  25. Re: Chart or Pivot Table to be included in the body of email VBA

    This thread is a duplicate of: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/1101484-how-include-pivot-table-chart-body-email.html
    Kindly read Mr Excel's policy in Rule 12...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4