Search:

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

Search: Search took 0.00 seconds.

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

    Also, Paul, I saw u teaching the other guy to do Mail Merge when both his files are stored on Sharepoint (but with a local copy). How did you manage to do that?
    ...
  2. Re: How to Open Word file (already having Mailmerged details) from excel

    My apologies. But really, is there anything I can do to avoid the duplicate issue?
  3. Re: How to Open Word file (already having Mailmerged details) from excel

    Yes because I figured that I should comment it out so that I won't close the mailmerge main document - which is the one I want only....
  4. Re: How to Open Word file (already having Mailmerged details) from excel

    Oh no. So what should I do? I'm really lost now
  5. Re: How to Open Word file (already having Mailmerged details) from excel

    I think I got it. It's the execute command that 'simulates' the activation of the mail merge (joining the files into a single letter). Removing it worked fine!

    Here is the code for those who wanna...
  6. Re: How to Open Word file (already having Mailmerged details) from excel

    Yes. I noticed that now.

    Thanks Paul. But just that one little issue I had. I'm not executing my code and it always opens with 2 documents. The one that joins and the one that doesn't. Can I just...
  7. Re: How to Open Word file (already having Mailmerged details) from excel

    ?activedocument.MailMerge.DataSource.Name
    I:\Shared drives\EdUHK SEC Department\SEC Departmental OSP.xlsm

    ?activedocument.MailMerge.DataSource.ConnectString...
  8. Re: How to Open Word file (already having Mailmerged details) from excel

    I checked and verified and I think it's not this part that rendered the error. I tested with the code like below now:


    Sub DoMailMerge()
    'Note: A VBA Reference to the Word Object Model is...
  9. Re: How to Open Word file (already having Mailmerged details) from excel

    But the file is synced locally

    Also, just to make sure I didn't make that statement out of no where, I also tried to do it locally. I copied the entire OneDrive synced file into Drive D, and tried...
  10. Re: How to Open Word file (already having Mailmerged details) from excel

    Thanks Paul. Having checked that I have a few findings:
    1) A bunch of the Jet OLEDB is missing. I guess it's intentional?
    2) I got the wrong SQL filter. But it seems to not affect anything. Changed...
  11. Re: How to Open Word file (already having Mailmerged details) from excel

    Dear Paul, yes indeed I did that.....even before I posted it. It just wouldn't work. It's very weird. This is what I got below, with the error code still persistent:

    BTW for the context of which I...
  12. Re: How to Open Word file (already having Mailmerged details) from excel

    Dear sir I'm unable to get past the error 91 "Object variable or With block variable not set". How do I circumvent that?
  13. Re: Call Word document (with mergefields ready) and MailMerge it from Excel (all hosted on Sharepoint)

    Getting something like this now, which is in similar structure i suppose, but not working with error 91: "Object Variable or With block variable not set"


    Private Sub CommandButton1_Click()
    ...
  14. Call Word document (with mergefields ready) and MailMerge it from Excel (all hosted on Sharepoint)

    I have to setup a series of mail merged forms for my school to invite guest speakers to our classrooms. For that, I have setup a table called Guest_Speaker_MM.
    I've already created all the merge...
  15. Re: Sum of Questionnaire Scores Based on a Domain Table

    The RAW data will be constantly modified and not maintained by me and thus I am not sure if I could change the format of the RAW table to the one you specified.....but appreciate the thought!
  16. Sum of Questionnaire Scores Based on a Domain Table

    I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6.

    I...
  17. Running Mail Merge from Excel on an Embedded .docx (Word) file

    Please help on figuring this out as I'm stuck at the last stage trying to properly define my variables in the following code.

    I want to execute the following in sequence:

    1. Click the button...
  18. AutoFill Method of Range Class Failed.......for a Filldown of Array Formula

    I have a table that goes from Column A to Column AW, starting at row 5 (with Row 4 being headers, and Row 1-3 for placing buttons, and a Summary Table

    Each row of the table depends on detecting a...
  19. Re: VBA determining 'Adults' and 'Children' based on Reference Number of Cases

    Sorry, not VBA is compulsory, just formula is fine too. I couldn't edit my title!
  20. VBA determining 'Adults' and 'Children' based on Reference Number of Cases

    The basic premise of the code I seek help is that

    1) Every family is assigned a reference number of 7 digits (e.g. 1001-012)
    2) Family is a mixture of different number of adults and children,...
  21. Replies
    1
    Views
    638

    Re: Dynamic Subject Line

    Please, anyone?
  22. Re: Real-time USERFORM VBA Concat Index-Match

    Bump/ Please help if any
  23. Real-time USERFORM VBA Concat Index-Match

    Hi guys,

    I'm quite a newbie in VBA and I've been trying to create a userform for a function that Concatenates all the Index Match Values from a table of clients' names based on a single value.
    ...
  24. Replies
    1
    Views
    638

    Dynamic Subject Line

    I'm a newcomer to VBA and has almost no knowledge to how to handle VBA except the very obvious parts.

    I'm working on a Workbook that will help me initiate Mail Merge in the following manners at...
Results 1 to 24 of 24