sswong98
10-17-2007, 04:58 PM
Hello,
I am new to VBA. Basically, I need to create a mail merge with charts. However, the charts are dynamic or changes for each recipeint. This mail merge display each individual compensation, so it will be different for each person.
Does anyone know how this can be done? I have created a mail merge, and can created a chart in the mail merge by inserting it in the mail merge document as an object. The issue is when I scroll from record to record, I can't figure out how to change the series dynamically.
I am new to VBA. Basically, I need to create a mail merge with charts. However, the charts are dynamic or changes for each recipeint. This mail merge display each individual compensation, so it will be different for each person.
Does anyone know how this can be done? I have created a mail merge, and can created a chart in the mail merge by inserting it in the mail merge document as an object. The issue is when I scroll from record to record, I can't figure out how to change the series dynamically.