Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    16
    Views
    489

    I think I'll just keep using my rechargeable...

    I think I'll just keep using my rechargeable batteries. Anyone with an interest in the environment and minimising battery expenditure would already be doing that...
  2. Replies
    34
    Views
    620

    Well, for starters, the...

    Well, for starters, the 'EmailDataSourceOutcome.doc' file attached to your previous post was not produced by running the macro against the 'Merge Data Table Makerfinal.doc' file attached to the same...
  3. [SOLVED] The fix is quite easy: simply select the entire...

    The fix is quite easy: simply select the entire TOC then click on the left-to-right paragraph arrow (i.e. with the ► symbol) on the Paragraph panel of the Ribbon's Home tab.
  4. Replies
    34
    Views
    620

    All the data are merged when I run the macro,...

    All the data are merged when I run the macro, including the last row with the 0s. On reflection, you don't need that row with this process.
  5. Replies
    1
    Views
    111

    If you mean HPS is a Style name, it's probably a...

    If you mean HPS is a Style name, it's probably a custom Style.
  6. Replies
    34
    Views
    620

    What do you mean by "It doesn't give me correct...

    What do you mean by "It doesn't give me correct info"?

    As the tutorial says of the ‘EmailDataSource.doc’ file:


    Regarding the totals, I see you're using the version of the field code that...
  7. Replies
    34
    Views
    620

    It's all covered in the section titled 'Merging...

    It's all covered in the section titled 'Merging by Catalog/Directory to E-Mail'.
  8. Replies
    34
    Views
    620

    If all you want to do is send the email in HTML...

    If all you want to do is send the email in HTML format, you should be able to do so using the material in the tutorial as is. If you need to send the actual table, rather than content in a tabular...
  9. [SOLVED] You could use code like: Sub Demo() Const...

    You could use code like:

    Sub Demo()
    Const StrNm1 As String = "D:\\work\doc1.xlsm", StrNm2 As String = "D:\\work\doc2.xlsm"
    Dim WkBk1 As Workbook, WkBk2 As Workbook, WkSht1 As Worksheet, WkSht2...
  10. Probably because you've actually added the code...

    Probably because you've actually added the code to Word's Normal template, or something such. If you did that, the macro would still be available to your mailmerge main document, even though not in...
  11. Replies
    19
    Views
    588

    FWIW, and I don't know whether it's applicable...

    FWIW, and I don't know whether it's applicable here, Word's VBA OpenDataSource method takes both a SQLStatement and SQLStatement1 parameter. For example:
    SQLStatement:="SELECT * FROM `Sheet1$`",...
  12. There's nothing about your latest attachments...

    There's nothing about your latest attachments that would account for that behaviour. Indeed, your attached 'Mailmerge Main Document.docm' file contains nothing more than a copy of the field code from...
  13. Replies
    34
    Views
    620

    That suggests your document has a Section (other...

    That suggests your document has a Section (other than the last Section) with no content.
  14. Replies
    34
    Views
    620

    What errors? Simply saying "I am getting errors"...

    What errors? Simply saying "I am getting errors" doesn't give anyone much to work with.
  15. Replies
    34
    Views
    620

    You need a Section break, not a Page break.

    You need a Section break, not a Page break.
  16. Replies
    34
    Views
    620

    No. Read post #13 again.

    No. Read post #13 again.
  17. The main problem that I can see is that your...

    The main problem that I can see is that your 'Email Merge Main Document.doc' has been connected to the data source. That and there's no code in your 'Main Mailmerge.docm' file. Finally, your...
  18. I don't know why you'd be getting doubled...

    I don't know why you'd be getting doubled content. There is nothing in the code to do that. The code explicitly takes whatever is in your source document, replicates it once in the target document,...
  19. Replies
    34
    Views
    620

    In your mailmerge main document's field code,...

    In your mailmerge main document's field code, where you see the field coded as '{QUOTE 12}', replace that with a pair of double quotes and insert a Section break between them.
  20. No, you should have two documents - your original...

    No, you should have two documents - your original and the output version with the same content, except that the new one will have the italics formatting (and no tags), where applicable. I have tested...
  21. Replies
    34
    Views
    620

    Did you change your mailmerge main document's...

    Did you change your mailmerge main document's code that inserts page breaks between groups to insert Section breaks instead?
  22. Replies
    34
    Views
    620

    That isn't the code I referred you to...

    That isn't the code I referred you to...
  23. Replies
    34
    Views
    620

    It doesn't matter which document you add it to,...

    It doesn't matter which document you add it to, provided the outcome document is the active one when the macro is run. It makes more sense, though, to add the macro to your mailmerge main document,...
  24. Replies
    34
    Views
    620

    That message is correct. You will need to send...

    That message is correct. You will need to send the merge output to file, then use the pages from that for your emails. That's why I gave you the link to the 'Split Merged Output to Separate...
  25. Replies
    34
    Views
    620

    To send the output for each formatted page as the...

    To send the output for each formatted page as the email body, you'll need to use Outlook as your default email program and send the emails in HTML format.

    If you want to send the pages as...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4