R
RisingSun78
Need some Help..
My disconnects mainly
pertain to the use of e-mail merge in Word 2007. The data file I need
to use currently resides in an Excel spreadsheet because of the need
for several formulas. I can merge most of the data successfully with
the exception of:
· Multiple rows of data per e-mail.
· Cannot edit individual e-mails prior to completing/sending
the merge. (This is possible with a regular letter merge, but cannot
do this with e-mail merge)
· Merging conditional formatting icons (if this is even
possible, I don't know) We're using OnMail Merge to merge .jpg images
as a workaround in place of the conditional formatting icons, but this
creates several more steps and takes a great deal of time.
· In general, need to write some macros to further automate
the process i.e., MMtoDocs to split the merge into separate scorecards
for records retention purposes.
Any Suggetions on how to do this?
Thanks, Joe
My disconnects mainly
pertain to the use of e-mail merge in Word 2007. The data file I need
to use currently resides in an Excel spreadsheet because of the need
for several formulas. I can merge most of the data successfully with
the exception of:
· Multiple rows of data per e-mail.
· Cannot edit individual e-mails prior to completing/sending
the merge. (This is possible with a regular letter merge, but cannot
do this with e-mail merge)
· Merging conditional formatting icons (if this is even
possible, I don't know) We're using OnMail Merge to merge .jpg images
as a workaround in place of the conditional formatting icons, but this
creates several more steps and takes a great deal of time.
· In general, need to write some macros to further automate
the process i.e., MMtoDocs to split the merge into separate scorecards
for records retention purposes.
Any Suggetions on how to do this?
Thanks, Joe