Email Merge with Attachments Being Overwritten Gixxer750 10/29/2008 12:14:03 AM I've been successfully using Doug Robbin's macro to send email merges with attachments, but I've run into a problem when I send more than 1 attachment. It looks like only the last attachment gets sent -- almost like my Word document isn't set up properly and the first attachment is being overwritten. Has anyone ever had this issue before, and can you suggest a fix -- thanks.

Re: Email Merge with Attachments Being Overwritten "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/29/2008 1:48:01 AM I have used the method to send multiple attachments. Are you sure that the file path\names are correct (INDENTICAL)? What is the layout of the catalog or directory type merge document that contains the email addresses in the first column and needs to include a column for each attachment.? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Gixxer750" <Gixxer750[ at ]discussions.microsoft.com> wrote in message news:AE7D757F-F870-47DA-8189-F1C44721A61E[ at ]microsoft.com... [Quoted Text] > I've been successfully using Doug Robbin's macro to send email merges with > attachments, but I've run into a problem when I send more than 1 > attachment. > It looks like only the last attachment gets sent -- almost like my Word > document isn't set up properly and the first attachment is being > overwritten. > > Has anyone ever had this issue before, and can you suggest a fix -- > thanks.

Re: Email Merge with Attachments Being Overwritten Gixxer750 10/29/2008 12:19:01 PM The filenames/path were different and correct. After more testing, I found when I changed my email preference to HTML from Rich Text, both files were indeed being sent out. For some reason, I could not see both attachments in my "Sent Items" log under Rich Text format. Thank you for the prompt reply and great macro. It's a huge time saver. "Doug Robbins - Word MVP" wrote: [Quoted Text] > I have used the method to send multiple attachments. Are you sure that the > file path\names are correct (INDENTICAL)? > > What is the layout of the catalog or directory type merge document that > contains the email addresses in the first column and needs to include a > column for each attachment.? > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Gixxer750" <Gixxer750[ at ]discussions.microsoft.com> wrote in message > news:AE7D757F-F870-47DA-8189-F1C44721A61E[ at ]microsoft.com... > > I've been successfully using Doug Robbin's macro to send email merges with > > attachments, but I've run into a problem when I send more than 1 > > attachment. > > It looks like only the last attachment gets sent -- almost like my Word > > document isn't set up properly and the first attachment is being > > overwritten. > > > > Has anyone ever had this issue before, and can you suggest a fix -- > > thanks. > > >