469,271 Members | 1,017 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Sending multiple attachments in one email to multiple address

alpnz
113 100+
Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.
  1. Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
  2. Group the attachments onto one email,
M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary
Dec 23 '06 #1
8 8170
MMcCarthy
14,534 Expert Mod 8TB
I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary

Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.

  1. Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
  2. Group the attachments onto one email,
M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary
Dec 25 '06 #2
alpnz
113 100+
I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary
Did you have a good Xmas, Hope so, cause this problem is not an easy fix I think. My Partners brother, tells me it is better to use a pdf creation product like Adobe, and build them outside of Access, but surely we don't have to resort to this.
Dec 28 '06 #3
NeoPa
32,171 Expert Mod 16PB
I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.
Dec 28 '06 #4
alpnz
113 100+
I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.
OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?
Dec 30 '06 #5
NeoPa
32,171 Expert Mod 16PB
I use that now.
I create the report normally and print to the Adobe printer which converts the print output to a PDF file.
Dec 30 '06 #6
MMcCarthy
14,534 Expert Mod 8TB
OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?
I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary
Jan 1 '07 #7
alpnz
113 100+
I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary
Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.
Jan 1 '07 #8
MMcCarthy
14,534 Expert Mod 8TB
Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.
Essentially you would add each report to the pdf as a new page or pages. This would require some kind of loop.

Mary
Jan 1 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by ColinWard | last post: by
2 posts views Thread by kimberly.shaffer | last post: by
6 posts views Thread by Anuradha | last post: by
7 posts views Thread by Ray Booysen | last post: by
8 posts views Thread by Mark | last post: by
3 posts views Thread by lizii | last post: by
7 posts views Thread by bleachie | last post: by
maliksleo
1 post views Thread by maliksleo | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.